6500: -- fnd_sessions to get req_data_as_of_date.
6501: FOR l_hr_position_rec IN
6502: (SELECT a.effective_start_date,
6503: a.effective_end_date
6504: FROM hr_all_positions_f a,
6505: psb_data_extracts b
6506: WHERE a.position_id =l_position_i_cache(i).hr_position_id
6507: AND b.data_extract_id = p_data_extract_id
6508: AND b.req_data_as_of_date between