APPS.PAY_GTNLOD_PKG dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 1839: l_payment_method_name pay_org_payment_methods_f.org_payment_method_name%TYPE;

1835:
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:

Line 1860: pay_org_payment_methods_f popm,

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
1863: where fcl.application_id(+) = 800
1864: and fcl.lookup_type(+) = 'US_ACCOUNT_TYPE'

Line 2068: PAY_ORG_PAYMENT_METHODS_F POPM,

2064: PAY_ACTION_INTERLOCKS PAI_RUN,
2065: PAY_PAYROLL_ACTIONS PPA_CHK,
2066: PAY_ASSIGNMENT_ACTIONS PAA_CHK,
2067: PAY_ACTION_INTERLOCKS PAI_CHK,
2068: PAY_ORG_PAYMENT_METHODS_F POPM,
2069: PAY_PRE_PAYMENTS PPP
2070: WHERE PAI_RUN.LOCKED_ACTION_ID = p_max_seq_aaid
2071: AND PAI_RUN.LOCKING_ACTION_ID = PAA_PPP.ASSIGNMENT_ACTION_ID
2072: AND PAA_PPP.ACTION_STATUS = 'C'