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.PER_CANCEL_HIRE_OR_APL_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 1558: from pay_element_entries_f

1554: where p_assignment_id = ppp.assignment_id;
1555:
1556: cursor csr_get_salary(p_assignment_id NUMBER) is
1557: select element_entry_id
1558: from pay_element_entries_f
1559: where assignment_id = p_assignment_id
1560: and creator_type = 'SP'
1561: and p_date_start between
1562: effective_start_date and effective_end_date;

Line 1567: from pay_element_entries_f

1563:
1564:
1565: cursor csr_chk_rec_exists(p_assignment_id NUMBER) is
1566: select element_entry_id
1567: from pay_element_entries_f
1568: where assignment_id = p_assignment_id
1569: and creator_type = 'SP'
1570: and (p_date_start - 1) between
1571: effective_start_date and effective_end_date;

Line 2367: from pay_element_entries_f

2363: where p_assignment_id = ppp.assignment_id;
2364:
2365: cursor csr_get_salary(p_assignment_id NUMBER) is
2366: select element_entry_id
2367: from pay_element_entries_f
2368: where assignment_id = p_assignment_id
2369: and creator_type = 'SP'
2370: and p_start_date between
2371: effective_start_date and effective_end_date;

Line 2376: from pay_element_entries_f

2372:
2373:
2374: cursor csr_chk_rec_exists(p_assignment_id NUMBER) is
2375: select element_entry_id
2376: from pay_element_entries_f
2377: where assignment_id = p_assignment_id
2378: and creator_type = 'SP'
2379: and (p_start_date - 1) between
2380: effective_start_date and effective_end_date;