APPS.PAY_GTNLOD_PKG dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 1660: l_payment_method_name pay_org_payment_methods_f.org_payment_method_name%TYPE;

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

Line 1681: pay_org_payment_methods_f popm,

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,
1683: pay_pre_payments ppp
1684: where fcl.application_id(+) = 800
1685: and fcl.lookup_type(+) = 'US_ACCOUNT_TYPE'

Line 1889: PAY_ORG_PAYMENT_METHODS_F POPM,

1885: PAY_ACTION_INTERLOCKS PAI_RUN,
1886: PAY_PAYROLL_ACTIONS PPA_CHK,
1887: PAY_ASSIGNMENT_ACTIONS PAA_CHK,
1888: PAY_ACTION_INTERLOCKS PAI_CHK,
1889: PAY_ORG_PAYMENT_METHODS_F POPM,
1890: PAY_PRE_PAYMENTS PPP
1891: WHERE PAI_RUN.LOCKED_ACTION_ID = p_max_seq_aaid
1892: AND PAI_RUN.LOCKING_ACTION_ID = PAA_PPP.ASSIGNMENT_ACTION_ID
1893: AND PAA_PPP.ACTION_STATUS = 'C'