DBA Data[Home] [Help]

APPS.PAY_PAYMENT_GL_ACCOUNTS_PKG dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 23: l_external_account_id pay_org_payment_methods_f.external_account_id%type;

19: where PAY_GL_ACCOUNT_ID = P_PAY_GL_ACCOUNT_ID
20: ;
21: --
22: l_def_gl_acct_id pay_payment_gl_accounts_f.pay_gl_account_id%type;
23: l_external_account_id pay_org_payment_methods_f.external_account_id%type;
24: l_org_payment_method_id pay_org_payment_methods_f.org_payment_method_id%type;
25: l_effective_start_date date;
26: l_effective_end_date date;
27: l_ovn number;

Line 24: l_org_payment_method_id pay_org_payment_methods_f.org_payment_method_id%type;

20: ;
21: --
22: l_def_gl_acct_id pay_payment_gl_accounts_f.pay_gl_account_id%type;
23: l_external_account_id pay_org_payment_methods_f.external_account_id%type;
24: l_org_payment_method_id pay_org_payment_methods_f.org_payment_method_id%type;
25: l_effective_start_date date;
26: l_effective_end_date date;
27: l_ovn number;
28: l_esd_out date;

Line 218: from pay_org_payment_methods_f

214: from dual;
215: --
216: cursor csr_opm_rows (p_org_payment_method_id number) is
217: select effective_start_date, effective_end_date, external_account_id
218: from pay_org_payment_methods_f
219: where org_payment_method_id = p_org_payment_method_id;
220: --
221: begin
222: --