APPS.PAY_ORG_PAYMENT_METHOD_API dependencies on PAY_PAYMENT_TYPES

Line 249: l_territory_code pay_payment_types.territory_code%TYPE;

245: l_external_account_id pay_org_payment_methods_f.external_account_id%TYPE;
246: l_asset_code_combination_id number;
247: l_language_code pay_org_payment_methods_f_tl.language%TYPE;
248: l_discard number;
249: l_territory_code pay_payment_types.territory_code%TYPE;
250: l_key_flex_id number;
251: l_defined_balance_id pay_org_payment_methods_f.defined_balance_id%TYPE;
252: l_currency_code pay_org_payment_methods_f.currency_code%TYPE;
253: l_PMETH_INFORMATION_CATEGORY pay_org_payment_methods_f.PMETH_INFORMATION_CATEGORY%TYPE;

Line 299: from pay_payment_types ppt,

295: order by db.business_group_id,db.legislation_code;
296: --
297: cursor csr_territory_code (v_payment_type_id number, v_business_group_id number) is
298: select nvl(ppt.territory_code,pbg.legislation_code)
299: from pay_payment_types ppt,
300: per_business_groups pbg
301: where ppt.payment_type_id = v_payment_type_id
302: and pbg.business_group_id = v_business_group_id;
303: --

Line 306: from pay_payment_types

302: and pbg.business_group_id = v_business_group_id;
303: --
304: cursor csr_currency_code (v_payment_type_id number) is
305: select currency_code
306: from pay_payment_types
307: where payment_type_id = v_payment_type_id;
308: --
309: cursor csr_chart_of_accounts_id (v_sets_of_book_id number) is
310: select CHART_OF_ACCOUNTS_ID

Line 316: from pay_payment_types

312: where SET_OF_BOOKS_ID = v_sets_of_book_id;
313: --
314: cursor csr_pmeth_category (v_payment_type_id number) is
315: select payment_type_name
316: from pay_payment_types
317: where payment_type_id = v_payment_type_id;
318: --
319: cursor csr_gl_accounts (v_external_account_id number) is
320: select gl_cash_ac_id,

Line 1758: l_territory_code pay_payment_types.territory_code%TYPE;

1754: l_external_account_id pay_org_payment_methods_f.external_account_id%TYPE;
1755: l_asset_code_combination_id number;
1756: l_language_code pay_org_payment_methods_f_tl.language%TYPE;
1757: l_discard number;
1758: l_territory_code pay_payment_types.territory_code%TYPE;
1759: l_business_group_id pay_org_payment_methods_f.business_group_id%TYPE;
1760: l_key_flex_id number;
1761: l_set_of_books_id number;
1762: l_asset_code_changed boolean;

Line 1798: from pay_payment_types pty

1794: l_pay_gl_account_id_out PAY_PAYMENT_GL_ACCOUNTS_F.PAY_GL_ACCOUNT_ID%TYPE;
1795: --
1796: cursor csr_territory_code (v_org_payment_method_id number) is
1797: select nvl(pty.territory_code,pbg.legislation_code)
1798: from pay_payment_types pty
1799: , pay_org_payment_methods_f opm
1800: , per_business_groups pbg
1801: where opm.org_payment_method_id = v_org_payment_method_id
1802: and pty.payment_type_id = opm.payment_type_id

Line 1808: pay_payment_types ppt

1804: --
1805: cursor csr_currency_code (v_org_payment_method_id number) is
1806: select ppt.currency_code
1807: from pay_org_payment_methods_f opm,
1808: pay_payment_types ppt
1809: where opm.org_payment_method_id = v_org_payment_method_id
1810: and ppt.payment_type_id = opm.payment_type_id;
1811: --
1812: cursor csr_business_group_id (v_org_payment_method_id number) is

Line 1831: from pay_payment_types ppt,

1827: and v_effective_date between effective_start_date and effective_end_date;
1828: --
1829: cursor csr_pmeth_category (v_org_payment_method_id number) is
1830: select ppt.payment_type_name
1831: from pay_payment_types ppt,
1832: pay_org_payment_methods_f opm
1833: where opm.org_payment_method_id = v_org_payment_method_id
1834: and ppt.payment_type_id = opm.payment_type_id;
1835: --