1189: hz_party_preferences pp1,
1190: iby_external_payers_all p,
1191: iby_pmt_instr_uses_all u,
1192: iby_ext_bank_accounts bank,
1193: hz_organization_profiles bapr,
1194: hz_organization_profiles brpr,
1195: iby_account_owners ow
1196: WHERE cust.cust_account_id = p_customer_id
1197: AND pp1.party_id = cust.party_id
1190: iby_external_payers_all p,
1191: iby_pmt_instr_uses_all u,
1192: iby_ext_bank_accounts bank,
1193: hz_organization_profiles bapr,
1194: hz_organization_profiles brpr,
1195: iby_account_owners ow
1196: WHERE cust.cust_account_id = p_customer_id
1197: AND pp1.party_id = cust.party_id
1198: AND pp1.category = 'LAST_USED_PAYMENT_INSTRUMENT'
1294: hz_cust_accounts cust,
1295: iby_external_payers_all p,
1296: iby_pmt_instr_uses_all u,
1297: iby_ext_bank_accounts bank,
1298: hz_organization_profiles bapr,
1299: hz_organization_profiles brpr,
1300: iby_account_owners ow
1301:
1302: WHERE
1295: iby_external_payers_all p,
1296: iby_pmt_instr_uses_all u,
1297: iby_ext_bank_accounts bank,
1298: hz_organization_profiles bapr,
1299: hz_organization_profiles brpr,
1300: iby_account_owners ow
1301:
1302: WHERE
1303: cust.cust_account_id = p_customer_id