APPS.HR_PAY_IF_PERSON_ARU dependencies on HR_PAY_INTERFACE_PKG

Line 16: nvl(hr_pay_interface_pkg.g_payroll_extract_date, sysdate) >= aa.effective_start_date AND

12: FROM per_all_assignments_f aa
13: WHERE
14: aa.primary_flag = 'Y' AND
15: aa.person_id = :old.person_id AND
16: nvl(hr_pay_interface_pkg.g_payroll_extract_date, sysdate) >= aa.effective_start_date AND
17: nvl(hr_pay_interface_pkg.g_payroll_extract_date, sysdate) <= aa.effective_end_date;
18: --
19: l_event_id NUMBER;
20: l_business_group_id NUMBER;

Line 17: nvl(hr_pay_interface_pkg.g_payroll_extract_date, sysdate) <= aa.effective_end_date;

13: WHERE
14: aa.primary_flag = 'Y' AND
15: aa.person_id = :old.person_id AND
16: nvl(hr_pay_interface_pkg.g_payroll_extract_date, sysdate) >= aa.effective_start_date AND
17: nvl(hr_pay_interface_pkg.g_payroll_extract_date, sysdate) <= aa.effective_end_date;
18: --
19: l_event_id NUMBER;
20: l_business_group_id NUMBER;
21: l_legislation_code VARCHAR2(10);

Line 55: hr_pay_interface_pkg.disable_emp_number_update (:old.employee_number,

51: RETURN;
52: END IF;
53: /* If the procedure hasn't exited at this point, run the trigger code*/
54:
55: hr_pay_interface_pkg.disable_emp_number_update (:old.employee_number,
56: :new.employee_number);
57: END IF;
58: end hr_pay_if_person_aru ;