DBA Data[Home] [Help]

APPS.PAY_GTNLOD_PKG dependencies on FND_COMMON_LOOKUPS

Line 1661: l_account_type fnd_common_lookups.meaning%TYPE;

1657: -- #1937448
1658:
1659: l_full_name per_all_people_f.full_name%TYPE;
1660: l_payment_method_name pay_org_payment_methods_f.org_payment_method_name%TYPE;
1661: l_account_type fnd_common_lookups.meaning%TYPE;
1662: l_account_number pay_external_accounts.segment3%TYPE;
1663: l_routing_number pay_external_accounts.segment4%TYPE;
1664:
1665: cursor person_details is -- #1937448

Line 1678: from fnd_common_lookups fcl,

1674: select popm.org_payment_method_name Payment_Method_Name,
1675: fcl.meaning,
1676: decode(pea.segment3,null,null,'*****'||substr(pea.segment3,-4,4)),
1677: substr(ltrim(pea.segment4),1,9)
1678: from fnd_common_lookups fcl,
1679: pay_external_accounts pea,
1680: pay_personal_payment_methods_f pppm,
1681: pay_org_payment_methods_f popm,
1682: pay_payment_types ppt,