DBA Data[Home] [Help]

APPS.HXT_UTIL dependencies on PER_ALL_ASSIGNMENTS_F

Line 595: , per_all_assignments_f asm

591: FROM
592: hxt_earning_policies egp
593: , hxt_holiday_calendars hcl
594: , hxt_per_aei_ddf_v aeiv
595: , per_all_assignments_f asm
596: WHERE asm.assignment_id = p_assignment_id
597: AND asm.assignment_id = aeiv.assignment_id
598: AND c_date between aeiv.effective_start_date
599: and aeiv.effective_end_date

Line 1833: l_asg_id per_all_assignments_f.assignment_id%TYPE;

1829: l_accrued_hrs NUMBER(7,3);
1830: l_batch_id NUMBER;
1831: l_old_total NUMBER;
1832:
1833: l_asg_id per_all_assignments_f.assignment_id%TYPE;
1834:
1835:
1836: BEGIN
1837: