APPS.PAY_MAINTAIN_BANK_ACCT dependencies on PAY_PRE_PAYMENTS

Line 61: -- FROM pay_pre_payments

57: SELECT 'X'
58: FROM SYS.DUAL
59: WHERE 1=2;
60: -- Need to change the following as well.
61: -- FROM pay_pre_payments
62: -- WHERE ORG_PAYMENT_METHOD_ID = p_org_payment_method_id;
63:
64: l_payroll_bank_account_id pay_org_payment_methods_f.external_account_id%TYPE;
65: l_dummy varchar2(2);

Line 160: pay_pre_payments ppp,

156: from
157: pay_org_payment_methods_f popm,
158: ce_bank_accounts cba,
159: ce_bank_acct_uses_all apb,
160: pay_pre_payments ppp,
161: pay_assignment_actions paa,
162: pay_payroll_actions ppa
163: where
164: paa.assignment_action_id = p_payment_id

Line 185: pay_pre_payments ppp,

181: from
182: pay_org_payment_methods_f popm,
183: ce_bank_accounts cba,
184: ce_bank_acct_uses_all apb,
185: pay_pre_payments ppp,
186: pay_assignment_actions paa,
187: pay_assignment_actions paa1,
188: pay_payroll_actions ppa,
189: pay_action_interlocks pai