APPS.JMF_GTA_TXT_OPERATOR_PROC dependencies on IBY_EXT_BANK_ACCOUNTS

Line 3298: l_bank_account_name IBY_EXT_BANK_ACCOUNTS.BANK_ACCOUNT_NAME%TYPE;

3294: l_alternate_name HZ_PARTIES.ORGANIZATION_NAME_PHONETIC%TYPE;
3295:
3296: l_phone_num Hz_Contact_Points.Phone_Number%TYPE;
3297: l_currency_code JMF_GTA_SYSTEM_PARAMETERS_ALL.Gt_Currency_Code%TYPE;
3298: l_bank_account_name IBY_EXT_BANK_ACCOUNTS.BANK_ACCOUNT_NAME%TYPE;
3299: l_bank_account_num IBY_EXT_BANK_ACCOUNTS.BANK_ACCOUNT_NUM%TYPE;
3300: l_address AR_ADDRESSES_V.concatenated_address%TYPE;
3301: l_address_phonenumber AR_ADDRESSES_V.concatenated_address%TYPE;
3302:

Line 3299: l_bank_account_num IBY_EXT_BANK_ACCOUNTS.BANK_ACCOUNT_NUM%TYPE;

3295:
3296: l_phone_num Hz_Contact_Points.Phone_Number%TYPE;
3297: l_currency_code JMF_GTA_SYSTEM_PARAMETERS_ALL.Gt_Currency_Code%TYPE;
3298: l_bank_account_name IBY_EXT_BANK_ACCOUNTS.BANK_ACCOUNT_NAME%TYPE;
3299: l_bank_account_num IBY_EXT_BANK_ACCOUNTS.BANK_ACCOUNT_NUM%TYPE;
3300: l_address AR_ADDRESSES_V.concatenated_address%TYPE;
3301: l_address_phonenumber AR_ADDRESSES_V.concatenated_address%TYPE;
3302:
3303: l_party_site_id hz_party_sites.party_site_id%TYPE;

Line 3643: , IBY_EXT_BANK_ACCOUNTS ibybanks

3639: , l_bank_account_num
3640: FROM (SELECT ibybanks.bank_account_name
3641: , ibybanks.bank_account_num
3642: FROM IBY_PMT_INSTR_USES_ALL ExtPartyInstrumentsEO
3643: , IBY_EXT_BANK_ACCOUNTS ibybanks
3644: WHERE ibybanks.EXT_BANK_ACCOUNT_ID = ExtPartyInstrumentsEO.instrument_id
3645: AND ExtPartyInstrumentsEO.INSTRUMENT_TYPE = 'BANKACCOUNT'
3646: AND ExtPartyInstrumentsEO.EXT_PMT_PARTY_ID = l_ext_payer_id
3647: AND ExtPartyInstrumentsEO.PAYMENT_FUNCTION = 'CUSTOMER_PAYMENT'