APPS.IBY_EXT_BANKACCT_PUB dependencies on IBY_EXTERNAL_PAYEES_ALL

Line 1215: iby_external_payees_all payees

1211: CURSOR c_supplier(p_acct_id NUMBER) IS
1212: SELECT owners.account_owner_party_id
1213: FROM iby_pmt_instr_uses_all instrument,
1214: IBY_ACCOUNT_OWNERS owners,
1215: iby_external_payees_all payees
1216: WHERE
1217: owners.primary_flag = 'Y' AND
1218: owners.ext_bank_account_id = p_acct_id AND
1219: owners.ext_bank_account_id = instrument.instrument_id AND

Line 1723: -- from iby_external_payees_all

1719: IF(p_supplier_site_id IS NOT NULL) THEN
1720: BEGIN
1721: --select party_site_id, org_id, org_type
1722: -- INTO l_party_site_id, l_org_id, l_org_type
1723: -- from iby_external_payees_all
1724: --where payee_party_id=p_ext_bank_acct_rec.acct_owner_party_id AND
1725: -- PAYMENT_FUNCTION='PAYABLES_DISB' AND
1726: -- SUPPLIER_SITE_ID =p_supplier_site_id;
1727: select org_id, vendor_site_id

Line 1779: from iby_external_payees_all

1775: IF(p_party_site_id IS NOT NULL AND p_org_id IS NOT NULL) THEN
1776: /*BEGIN
1777: select org_type
1778: INTO l_org_type
1779: from iby_external_payees_all
1780: where payee_party_id=p_ext_bank_acct_rec.acct_owner_party_id AND
1781: PAYMENT_FUNCTION='PAYABLES_DISB' AND
1782: PARTY_SITE_ID =p_party_site_id AND
1783: ORG_ID = p_org_id AND

Line 1991: iby_external_payees_all payees

1987: CURSOR c_supplier(p_acct_id NUMBER) IS
1988: SELECT owners.account_owner_party_id
1989: FROM iby_pmt_instr_uses_all instrument,
1990: IBY_ACCOUNT_OWNERS owners,
1991: iby_external_payees_all payees
1992: WHERE
1993: owners.primary_flag = 'Y' AND
1994: owners.ext_bank_account_id = p_acct_id AND
1995: owners.ext_bank_account_id = instrument.instrument_id AND