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 1351: FROM per_all_assignments_f asg,

1347: AND paa1.absence_attendance_id = p_absence_attendance_id
1348: AND asg1.person_id = paa1.person_id
1349: AND asg1.assignment_id not in (
1350: SELECT asg.assignment_id
1351: FROM per_all_assignments_f asg,
1352: per_absence_attendances paa
1353: WHERE paa.absence_attendance_id = p_absence_attendance_id
1354: AND asg.person_id = paa.person_id
1355: AND nvl(paa.date_start,asg.effective_end_date) <= asg.effective_end_date

Line 1706: FROM per_all_assignments_f asg,

1702:
1703:
1704: CURSOR csr_assignments IS
1705: SELECT asg.assignment_id, asg.effective_start_date
1706: FROM per_all_assignments_f asg,
1707: per_absence_attendances paa
1708: WHERE paa.absence_attendance_id = p_absence_attendance_id
1709: and asg.person_id = paa.person_id
1710: AND nvl(paa.date_start,asg.effective_end_date) <= asg.effective_end_date

Line 1720: ,per_all_assignments_f asg

1716: ,pet.processing_type processing_type
1717: ,pee.effective_start_date effective_start_date
1718: ,pee.effective_end_date effective_end_date
1719: from per_absence_attendances abs
1720: ,per_all_assignments_f asg
1721: ,pay_element_types_f pet
1722: ,pay_element_links_f pel
1723: ,pay_element_entries_f pee
1724: ,pay_element_entry_values_f peev

Line 1754: ,per_all_assignments_f asg

1750: ,pet.processing_type processing_type
1751: ,pee.effective_start_date effective_start_date
1752: ,pee.effective_end_date effective_end_date
1753: from per_absence_attendances abs
1754: ,per_all_assignments_f asg
1755: ,pay_element_types_f pet
1756: ,pay_element_links_f pel
1757: ,pay_element_entries_f pee
1758: where abs.absence_attendance_id = p_absence_attendance_id