eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GTNLOD_PKG dependencies on PAY_EXTERNAL_ACCOUNTS

Line 1841: l_account_number pay_external_accounts.segment3%TYPE;

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
1845: select ppf.full_name

Line 1842: l_routing_number pay_external_accounts.segment4%TYPE;

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
1845: select ppf.full_name
1846: from per_all_people_f ppf

Line 1858: pay_external_accounts pea,

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,
1862: pay_pre_payments ppp