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;
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
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
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
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