DBA Data[Home] [Help]

APPS.PAY_ZA_EFT_RECONCILIATION dependencies on PAY_PRE_PAYMENTS

Line 21: pay_pre_payments ppp,

17: CURSOR c_get_trx_date
18: IS
19: Select to_char(nvl(ppa.overriding_dd_date, nvl(ptp.default_dd_date, ptp.end_date)), 'YYYY/MM/DD')
20: from pay_assignment_actions paa,
21: pay_pre_payments ppp,
22: pay_assignment_actions paa2,
23: pay_payroll_actions ppa,
24: per_time_periods ptp
25: where paa.assignment_action_id = p_assignment_action_id

Line 58: pay_pre_payments ppp,

54:
55: cursor acb_effective_date IS
56: select ppa.effective_date
57: from pay_assignment_actions paa,
58: pay_pre_payments ppp,
59: pay_assignment_actions paa2,
60: pay_payroll_actions ppa
61: where paa.assignment_action_id = p_assignment_action_id
62: and paa.PRE_PAYMENT_ID = ppp.PRE_PAYMENT_ID