eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_LOC_ABSENCE dependencies on PER_ALL_ASSIGNMENTS_F

Line 53: ,per_all_assignments_f asg

49: ,pet.processing_type processing_type
50: ,pee.effective_start_date effective_start_date
51: ,pee.effective_end_date effective_end_date
52: from per_absence_attendances abs
53: ,per_all_assignments_f asg
54: ,pay_element_types_f pet
55: ,pay_element_links_f pel
56: ,pay_element_entries_f pee
57: ,pay_element_entry_values_f peev

Line 85: ,per_all_assignments_f asg

81: ,pet.processing_type processing_type
82: ,pee.effective_start_date effective_start_date
83: ,pee.effective_end_date effective_end_date
84: from per_absence_attendances abs
85: ,per_all_assignments_f asg
86: ,pay_element_types_f pet
87: ,pay_element_links_f pel
88: ,pay_element_entries_f pee
89: where abs.absence_attendance_id = p_absence_attendance_id

Line 514: FROM per_all_assignments_f asg,

510: -- Find all assignments for the person as of a given date.
511: -- Bug no 5020916. Order by clause included in the cursor
512: CURSOR csr_assignments(p_person_id NUMBER, p_effective_date DATE) IS
513: SELECT asg.assignment_id, asg.effective_start_date, asg.effective_end_date
514: FROM per_all_assignments_f asg,
515: per_absence_attendances paa
516: WHERE paa.absence_attendance_id = p_absence_attendance_id
517: and asg.person_id = paa.person_id
518: AND nvl(paa.date_start,asg.effective_end_date) <= asg.effective_end_date

Line 908: ,per_all_assignments_f asg

904: ,pet.processing_type processing_type
905: ,pee.effective_start_date effective_start_date
906: ,pee.effective_end_date effective_end_date
907: from per_absence_attendances abs
908: ,per_all_assignments_f asg
909: ,pay_element_types_f pet
910: ,pay_element_links_f pel
911: ,pay_element_entries_f pee
912: ,pay_element_entry_values_f peev

Line 938: ,per_all_assignments_f asg

934: ,pet.processing_type
935: ,pee.effective_start_date
936: ,pee.effective_end_date
937: from per_absence_attendances abs
938: ,per_all_assignments_f asg
939: ,pay_element_types_f pet
940: ,pay_element_links_f pel
941: ,pay_element_entries_f pee
942: where abs.absence_attendance_id = p_absence_attendance_id

Line 1315: FROM per_all_assignments_f asg,

1311: -- Find all assignments for the person as of a given date.
1312: -- Bug no 5020916. Order by clause included in the cursor
1313: CURSOR csr_assignments(p_person_id NUMBER, p_effective_date DATE) IS
1314: SELECT asg.assignment_id, asg.effective_start_date, asg.effective_end_date
1315: FROM per_all_assignments_f asg,
1316: per_absence_attendances paa
1317: WHERE paa.absence_attendance_id = p_absence_attendance_id
1318: and asg.person_id = paa.person_id
1319: and paa.person_id = p_person_id

Line 1344: per_all_assignments_f asg1,

1340:
1341: CURSOR csr_invalid_entries (p_element_type_id NUMBER) IS
1342: SELECT pee.element_entry_id, pee.effective_start_date
1343: FROM pay_element_entries_f pee,
1344: per_all_assignments_f asg1,
1345: per_absence_attendances paa1
1346: where pee.element_type_id = p_element_type_id
1347: AND paa1.absence_attendance_id = p_absence_attendance_id
1348: AND asg1.person_id = paa1.person_id

Line 1353: FROM per_all_assignments_f asg,

1349: AND asg1.assignment_id = pee.assignment_id --9971535
1350: AND pee.effective_start_date between asg1.effective_start_date AND asg1.effective_end_date --9971535
1351: AND asg1.assignment_id not in (
1352: SELECT asg.assignment_id
1353: FROM per_all_assignments_f asg,
1354: per_absence_attendances paa
1355: WHERE paa.absence_attendance_id = p_absence_attendance_id
1356: AND asg.person_id = paa.person_id
1357: AND nvl(paa.date_start,asg.effective_end_date) <= asg.effective_end_date

Line 1714: FROM per_all_assignments_f asg,

1710:
1711:
1712: CURSOR csr_assignments IS
1713: SELECT asg.assignment_id, asg.effective_start_date
1714: FROM per_all_assignments_f asg,
1715: per_absence_attendances paa
1716: WHERE paa.absence_attendance_id = p_absence_attendance_id
1717: and asg.person_id = paa.person_id
1718: AND nvl(paa.date_start,asg.effective_end_date) <= asg.effective_end_date

Line 1728: ,per_all_assignments_f asg

1724: ,pet.processing_type processing_type
1725: ,pee.effective_start_date effective_start_date
1726: ,pee.effective_end_date effective_end_date
1727: from per_absence_attendances abs
1728: ,per_all_assignments_f asg
1729: ,pay_element_types_f pet
1730: ,pay_element_links_f pel
1731: ,pay_element_entries_f pee
1732: ,pay_element_entry_values_f peev

Line 1762: ,per_all_assignments_f asg

1758: ,pet.processing_type processing_type
1759: ,pee.effective_start_date effective_start_date
1760: ,pee.effective_end_date effective_end_date
1761: from per_absence_attendances abs
1762: ,per_all_assignments_f asg
1763: ,pay_element_types_f pet
1764: ,pay_element_links_f pel
1765: ,pay_element_entries_f pee
1766: where abs.absence_attendance_id = p_absence_attendance_id