APPS.PER_CANCEL_HIRE_OR_APL_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 1447: from pay_element_entries_f

1443: where p_assignment_id = ppp.assignment_id;
1444:
1445: cursor csr_get_salary(p_assignment_id NUMBER) is
1446: select element_entry_id
1447: from pay_element_entries_f
1448: where assignment_id = p_assignment_id
1449: and creator_type = 'SP'
1450: and p_start_date between
1451: effective_start_date and effective_end_date;

Line 1456: from pay_element_entries_f

1452:
1453:
1454: cursor csr_chk_rec_exists(p_assignment_id NUMBER) is
1455: select element_entry_id
1456: from pay_element_entries_f
1457: where assignment_id = p_assignment_id
1458: and creator_type = 'SP'
1459: and (p_start_date - 1) between
1460: effective_start_date and effective_end_date;