APPS.HXT_TRAN_PA dependencies on HXT_DET_HOURS_WORKED_X

Line 60: FROM hxt_det_hours_worked_x det

56: where ppf2.person_id = tim.for_person_id
57: and ppf2.effective_end_date >= ptp.START_date
58: and ppf2.effective_start_date <= ptp.END_date)
59: AND EXISTS (SELECT 'Y'
60: FROM hxt_det_hours_worked_x det
61: WHERE det.tim_id = tim.id
62: AND det.pa_status = 'P');
63: --SIR420 START Don't skip rows with errors because errors are deleted in cursor below
64: -- AND NOT EXISTS (SELECT 'X'

Line 353: FROM hxt_det_hours_worked_x det,

349: asg.organization_id,
350: det.element_type_id,
351: asg.assignment_id,
352: asg.assignment_number
353: FROM hxt_det_hours_worked_x det,
354: hxt_sum_hours_worked_x shw,
355: per_assignments_f asg,
356: per_pay_bases ppb,
357: per_pay_proposals pro,

Line 717: FROM hxt_det_hours_worked_x det2

713: end if;
714: UPDATE hxt_det_hours_worked_f detf
715: SET detf.pa_status = 'C'
716: WHERE detf.rowid = (SELECT det2.rowid
717: FROM hxt_det_hours_worked_x det2
718: WHERE l_non_rec.id = det2.id);
719: END LOOP;
720: if g_debug then
721: hr_utility.set_location('HXT_TRAN_PA.non_eff_wage_rate_transfer',350);