APPS.HR_PAY_IF_PPM_NO_UPDATE_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: --
19: l_event_id NUMBER;

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: --
19: l_event_id NUMBER;
20: l_business_group_id NUMBER;

Line 57: hr_pay_interface_pkg.disable_ppm_update (:old.priority,

53: RETURN;
54: END IF;
55: /* If the procedure hasn't exited at this point, run the trigger code*/
56:
57: hr_pay_interface_pkg.disable_ppm_update (:old.priority,
58: :new.priority);
59: END IF;
60: end hr_pay_if_ppm_no_update_aru ;