DBA Data[Home] [Help]

APPS.PAY_GTNLOD_PKG dependencies on FND_COMMON_LOOKUPS

Line 1840: l_account_type fnd_common_lookups.meaning%TYPE;

1836: -- #1937448
1837:
1838: l_full_name per_all_people_f.full_name%TYPE;
1839: l_payment_method_name pay_org_payment_methods_f.org_payment_method_name%TYPE;
1840: l_account_type fnd_common_lookups.meaning%TYPE;
1841: l_account_number pay_external_accounts.segment3%TYPE;
1842: l_routing_number pay_external_accounts.segment4%TYPE;
1843:
1844: cursor person_details is -- #1937448

Line 1857: from fnd_common_lookups fcl,

1853: select popm.org_payment_method_name Payment_Method_Name,
1854: fcl.meaning,
1855: decode(pea.segment3,null,null,'*****'||substr(pea.segment3,-4,4)),
1856: substr(ltrim(pea.segment4),1,9)
1857: from fnd_common_lookups fcl,
1858: pay_external_accounts pea,
1859: pay_personal_payment_methods_f pppm,
1860: pay_org_payment_methods_f popm,
1861: pay_payment_types ppt,