APPS.PAY_NZ_EFT dependencies on PAY_PRE_PAYMENTS

Line 54: (c_pre_payment_id pay_pre_payments.pre_payment_id%TYPE

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
55: ,c_effective_date DATE)
56: IS
57: SELECT SUBSTR(pea.segment1,3,4)||SUBSTR(LPAD(pea.segment2,8,'0'),2,7)
58: FROM pay_pre_payments ppp

Line 58: FROM pay_pre_payments ppp

54: (c_pre_payment_id pay_pre_payments.pre_payment_id%TYPE
55: ,c_effective_date DATE)
56: IS
57: SELECT SUBSTR(pea.segment1,3,4)||SUBSTR(LPAD(pea.segment2,8,'0'),2,7)
58: FROM pay_pre_payments ppp
59: ,pay_personal_payment_methods_f ppmf
60: ,pay_external_accounts pea
61: WHERE ppp.pre_payment_id = c_pre_payment_id
62: AND ppp.personal_payment_method_id = ppmf.personal_payment_method_id

Line 79: CURSOR get_batch_due_date(c_pre_payment_id pay_pre_payments.pre_payment_id%TYPE)

75: AND to_char(hou.organization_id) = paa.tax_unit_id;
76:
77: /*Bug#7614146 -New Cursor added to fetch the batch_due_date from the payroll tables*/
78:
79: CURSOR get_batch_due_date(c_pre_payment_id pay_pre_payments.pre_payment_id%TYPE)
80: IS
81: SELECT to_char(ptp.default_dd_date,'YYYYMMDD')
82: FROM pay_assignment_actions paa,
83: pay_pre_payments ppp,

Line 83: pay_pre_payments ppp,

79: CURSOR get_batch_due_date(c_pre_payment_id pay_pre_payments.pre_payment_id%TYPE)
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