APPS.PAY_MAINTAIN_BANK_ACCT dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 53: -- or EXISTS (SELECT 'X' FROM pay_org_payment_methods_f

49: having count(*) >1));
50: -- Need to check whether the payment is reconcilled.
51: -- If so then we should not allow the change of the bank account.
52: -- Following needs to be changed later.
53: -- or EXISTS (SELECT 'X' FROM pay_org_payment_methods_f
54: -- WHERE ORG_PAYMENT_METHOD_ID = p_org_payment_method_id);
55:
56: CURSOR csr_chk_pre_payments_exists IS
57: SELECT 'X'

Line 64: l_payroll_bank_account_id pay_org_payment_methods_f.external_account_id%TYPE;

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);
66: l_proc varchar2(100) := g_package||'UPDATE_PAYROLL_BANK_ACCT';
67:
68: begin

Line 157: pay_org_payment_methods_f popm,

153: nvl(ppp.base_currency_value,ppp.value) base_currency_value,
154: paa.action_status,
155: popm.business_group_id
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,

Line 182: pay_org_payment_methods_f popm,

178: nvl(ppp.base_currency_value,ppp.value) base_currency_value,
179: paa.action_status,
180: popm.business_group_id
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,

Line 298: from pay_org_payment_methods_f opm,

294: cursor csr_ap_details(c_org_payment_method_id number,
295: c_validation_start_date date,
296: c_validation_end_date date) is
297: select null
298: from pay_org_payment_methods_f opm,
299: ce_bank_accounts cba,
300: ce_bank_acct_uses_all cbau
301: where cba.bank_account_id = cbau.bank_account_id
302: and opm.org_payment_method_id = c_org_payment_method_id