58: where ppf2.person_id = tim.for_person_id
59: and ppf2.effective_end_date >= ptp.START_date
60: and ppf2.effective_start_date <= ptp.END_date)
61: AND EXISTS (SELECT 'Y'
62: FROM hxt_det_hours_worked_x det
63: WHERE det.tim_id = tim.id
64: AND det.pa_status = 'R') ;
65: BEGIN
66: -- select each timecard within the payroll/time-period
145: -- Update all retro rows processed to show completed
146: UPDATE hxt_det_hours_worked_f
147: SET pa_status = 'C'
148: WHERE rowid IN (SELECT d.rowid
149: FROM hxt_det_hours_worked_x d
150: WHERE d.pa_status = 'R'
151: AND d.tim_id = l_timecard_rec.id);
152:
153: COMMIT; -- commit data for this timecard
317: asg.assignment_id,
318: asg.assignment_number,
319: det.parent_id,
320: det.element_type_id
321: FROM hxt_det_hours_worked_x det,
322: per_pay_proposals pro,
323: per_pay_bases ppb,
324: hr_lookups fcl,
325: hr_lookups fcl2,