APPS.AR_GTA_TXT_OPERATOR_PROC dependencies on IBY_EXTERNAL_PAYERS_ALL

Line 3615: l_ext_payer_id IBY_EXTERNAL_PAYERS_ALL.ext_payer_id%TYPE;

3611:
3612: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
3613: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
3614:
3615: l_ext_payer_id IBY_EXTERNAL_PAYERS_ALL.ext_payer_id%TYPE;
3616: --Yao Zhang fix bug 7670710 add begin
3617: l_bank_name HZ_PARTIES.party_name%TYPE;
3618: l_bank_branch_name HZ_PARTIES.party_name%TYPE;
3619: --Yao Zhang fix bug#7670710 add end

Line 4009: IBY_EXTERNAL_PAYERS_ALL

4005: ext_payer_id
4006: INTO
4007: l_ext_payer_id
4008: FROM
4009: IBY_EXTERNAL_PAYERS_ALL
4010: WHERE party_id = l_party_id
4011: AND CUST_ACCOUNT_ID = l_customer_id -- site account id
4012: AND ACCT_SITE_USE_ID = l_customer_site_use_id -- site use id
4013: AND ORG_ID = p_org_id -- org id