DBA Data[Home] [Help]

APPS.AR_IREC_PAYMENTS dependencies on IBY_ACCOUNT_OWNERS

Line 1266: iby_account_owners ow

1262: iby_pmt_instr_uses_all u,
1263: iby_ext_bank_accounts bank,
1264: hz_organization_profiles bapr,
1265: hz_organization_profiles brpr,
1266: iby_account_owners ow
1267: WHERE cust.cust_account_id = p_customer_id
1268: AND pp1.party_id = cust.party_id
1269: AND pp1.category = 'LAST_USED_PAYMENT_INSTRUMENT'
1270: AND pp1.preference_code = 'INSTRUMENT_ID'

Line 1368: iby_account_owners ow

1364: iby_pmt_instr_uses_all u,
1365: iby_ext_bank_accounts bank,
1366: hz_organization_profiles bapr,
1367: hz_organization_profiles brpr,
1368: iby_account_owners ow
1369:
1370: WHERE
1371: cust.cust_account_id = p_customer_id
1372: AND p.cust_account_id = cust.cust_account_id

Line 3305: FROM IBY_ACCOUNT_OWNERS

3301: END IF;
3302: -- Added for Bug#16306925
3303: if(p_payment_instrument = 'BANK_ACCOUNT') then
3304: SELECT COUNT(*) INTO l_count
3305: FROM IBY_ACCOUNT_OWNERS
3306: WHERE ACCOUNT_OWNER_PARTY_ID = p_payer_party_id
3307: AND EXT_BANK_ACCOUNT_ID = l_bank_account_id;
3308:
3309: if(l_count <= 0) then