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.HR_PAY_IF_PPM_NO_UPDATE2_ARU dependencies on HR_PAY_INTERFACE_PKG

Line 15: nvl(HR_PAY_INTERFACE_PKG.g_payroll_extract_date, sysdate) >= aa.effective_start_date AND

11: SELECT aa.payroll_id
12: FROM per_all_assignments_f aa
13: WHERE
14: :old.assignment_id = aa.assignment_id AND
15: nvl(HR_PAY_INTERFACE_PKG.g_payroll_extract_date, sysdate) >= aa.effective_start_date AND
16: nvl(HR_PAY_INTERFACE_PKG.g_payroll_extract_date, sysdate) <= aa.effective_end_date;
17: --
18: CURSOR csr_get_old_segments IS
19: SELECT ea.segment3, ea.segment2, ea.segment4

Line 16: nvl(HR_PAY_INTERFACE_PKG.g_payroll_extract_date, sysdate) <= aa.effective_end_date;

12: FROM per_all_assignments_f aa
13: WHERE
14: :old.assignment_id = aa.assignment_id AND
15: nvl(HR_PAY_INTERFACE_PKG.g_payroll_extract_date, sysdate) >= aa.effective_start_date AND
16: nvl(HR_PAY_INTERFACE_PKG.g_payroll_extract_date, sysdate) <= aa.effective_end_date;
17: --
18: CURSOR csr_get_old_segments IS
19: SELECT ea.segment3, ea.segment2, ea.segment4
20: FROM pay_external_accounts ea