APPS.PAY_NZ_EFT dependencies on PAY_PAYROLL_ACTIONS

Line 47: (c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)

43: l_eff_date DATE;
44: l_nbnz_account VARCHAR2(20);
45: l_legal_employer VARCHAR2(250);
46: CURSOR get_effective_date
47: (c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
48: IS
49: SELECT ppa.effective_date
50: FROM pay_payroll_actions ppa
51: WHERE ppa.payroll_action_id = c_payroll_action_id;

Line 50: FROM pay_payroll_actions ppa

46: CURSOR get_effective_date
47: (c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
48: IS
49: SELECT ppa.effective_date
50: FROM pay_payroll_actions ppa
51: WHERE ppa.payroll_action_id = c_payroll_action_id;
52:
53: CURSOR get_nbnz_account_information
54: (c_pre_payment_id pay_pre_payments.pre_payment_id%TYPE

Line 67: (c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE

63: AND ppmf.external_account_id = pea.external_account_id
64: AND c_effective_date BETWEEN ppmf.effective_start_date AND ppmf.effective_end_date;
65:
66: CURSOR get_legal_employer_info
67: (c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE
68: ,c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
69: IS
70: SELECT hou.name
71: FROM pay_assignment_actions paa,

Line 84: pay_payroll_actions ppa,

80: IS
81: SELECT to_char(ptp.default_dd_date,'YYYYMMDD')
82: FROM pay_assignment_actions paa,
83: pay_pre_payments ppp,
84: pay_payroll_actions ppa,
85: pay_action_interlocks pai,
86: per_time_periods ptp
87: WHERE ppp.pre_payment_id = c_pre_payment_id
88: AND pai.locking_action_id = ppp.assignment_action_id