how it possible?...

UPDATE GL_CALENDAR_LINES

SET CAL_HEADER_ID = @PVC_CALENDAR_HEADER_ID,

PERIOD_NAME = @lvc_period_name, FROM_DATE = @ld_from_date_1,

TO_DATE = @ld_to_date_1, QUARTER_NUM = @li_quarter_num,

F_YEAR = @lvc_f_year, ADJUSTING_PERIOD = @li_adjusting_period,

TRN = @PBI_TRN, STATUS = 1, SESSION_ID = @PBI_SESSION_ID

WHERE CAL_LINE_ID = @li_actual_line_id

since values comes from some other table.. how can u single update would be enough?..kindly can u pls explain ?