APPS.PAY_IN_FORM_24Q_WEB_ADI dependencies on PAY_ELEMENT_ENTRIES_F

Line 267: FROM pay_element_entries_f

263: CURSOR c_element_details
264: IS
265: SELECT effective_start_date
266: ,assignment_id
267: FROM pay_element_entries_f
268: WHERE element_entry_id = p_element_entry_id;
269:
270: l_effective_date DATE;
271: l_assignment_id NUMBER;

Line 393: FROM pay_element_entries_f

389: CURSOR c_element_details
390: IS
391: SELECT effective_start_date
392: ,assignment_id
393: FROM pay_element_entries_f
394: WHERE element_entry_id = p_element_entry_id;
395:
396: CURSOR c_prepayment_record(p_assignment_id NUMBER
397: ,p_effective_date DATE

Line 838: FROM pay_element_entries_f entry

834: SELECT element_type_id
835: ,element_link_id
836: ,asg.assignment_id
837: ,entry.object_version_number
838: FROM pay_element_entries_f entry
839: ,per_assignments_f asg
840: WHERE asg.business_group_id = p_business_group_id
841: AND asg.assignment_id = entry.assignment_id
842: AND entry.element_entry_id = p_element_entry_id

Line 890: FROM pay_element_entries_f

886: -- Cursor to retreive the element effective start date
887: CURSOR c_effective_start_date
888: IS
889: SELECT effective_start_date,object_version_number
890: FROM pay_element_entries_f
891: WHERE element_entry_id = p_element_entry_id
892: ORDER BY object_version_number DESC;
893:
894: -- Cursor to determine the employee number

Line 904: ,pay_element_entries_f entry

900: IS
901: SELECT 1
902: FROM per_people_f pep
903: ,per_assignments_f asg
904: ,pay_element_entries_f entry
905: WHERE entry.element_entry_id = p_element_entry_id
906: AND asg.assignment_id = entry.assignment_id
907: AND asg.person_id = pep.person_id
908: AND asg.business_group_id = pep.business_group_id