280: l_primary_flag VARCHAR2(1); -- Dummy return for primary_flag
281: l_warning VARCHAR2(1); -- Dummy return for warning;
282: --
283: --start WWBUG 2130950 hrwf synchronization --tpapired
284: l_asg_rec per_all_assignments_f%rowtype;
285: cursor l_asg_cur is
286: select *
287: from per_all_assignments_f
288: where assignment_id = L_ASSIGNMENT_ID
283: --start WWBUG 2130950 hrwf synchronization --tpapired
284: l_asg_rec per_all_assignments_f%rowtype;
285: cursor l_asg_cur is
286: select *
287: from per_all_assignments_f
288: where assignment_id = L_ASSIGNMENT_ID
289: and effective_start_date = P_EFFECTIVE_START_DATE
290: and effective_end_date = P_EFFECTIVE_END_DATE;
291: --End WWBUG 2130950 for testing hrwf synchronization -tpapired