APPS.HR_LOC_ABSENCE dependencies on PAY_ELEMENT_ENTRIES_F

Line 56: ,pay_element_entries_f pee

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
58: ,pay_input_values_f piv
59: where abs.absence_attendance_id = p_absence_attendance_id
60: and abs.person_id = asg.person_id

Line 88: ,pay_element_entries_f pee

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
90: and abs.person_id = asg.person_id
91: and asg.assignment_id = p_assignment_id
92: and abs.date_start <= asg.effective_end_date

Line 911: ,pay_element_entries_f pee

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
913: ,pay_input_values_f piv
914: where abs.absence_attendance_id = p_absence_attendance_id
915: and abs.person_id = asg.person_id

Line 941: ,pay_element_entries_f pee

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
943: and abs.person_id = asg.person_id
944: and asg.assignment_id = p_assignment_id
945: and nvl(abs.date_start,asg.effective_end_date) <= asg.effective_end_date

Line 1343: FROM pay_element_entries_f pee,

1339:
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

Line 1731: ,pay_element_entries_f pee

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
1733: ,pay_input_values_f piv
1734: where abs.absence_attendance_id = p_absence_attendance_id
1735: and abs.person_id = asg.person_id

Line 1765: ,pay_element_entries_f pee

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
1767: and abs.person_id = asg.person_id
1768: and asg.assignment_id = p_assignment_id
1769: and nvl(abs.date_start,asg.effective_end_date) <= asg.effective_end_date