[Home] [Help]
1257: bank.branch_id branch_party_id,
1258: bank.object_version_number
1259: FROM hz_cust_accounts cust,
1260: hz_party_preferences pp1,
1261: iby_external_payers_all p,
1262: iby_pmt_instr_uses_all u,
1263: iby_ext_bank_accounts bank,
1264: hz_organization_profiles bapr,
1265: hz_organization_profiles brpr,
1310: NULL branch_party_id,
1311: NULL object_version_number
1312: FROM hz_cust_accounts cust,
1313: hz_party_preferences pp1,
1314: iby_external_payers_all p,
1315: IBY_FNDCPT_PAYER_ASSGN_INSTR_V c,
1316: hz_parties hzcc,
1317: hz_party_site_uses psu,
1318: hz_party_sites hps,
1359: bank.branch_id branch_party_id,
1360: bank.object_version_number
1361: FROM
1362: hz_cust_accounts cust,
1363: iby_external_payers_all p,
1364: iby_pmt_instr_uses_all u,
1365: iby_ext_bank_accounts bank,
1366: hz_organization_profiles bapr,
1367: hz_organization_profiles brpr,
1415: FROM
1416: fnd_lookup_values_vl ccunk,
1417: iby_creditcard c,
1418: iby_creditcard_issuers_vl i,
1419: iby_external_payers_all p,
1420: iby_pmt_instr_uses_all u,
1421: hz_parties hzcc,
1422: hz_cust_accounts cust,
1423: hz_party_site_uses psu,
2965:
2966: CURSOR chk_instr_assigned_cur(l_bank_account_id NUMBER, p_customer_id NUMBER, p_customer_site_id NUMBER) IS
2967: select INSTRUMENT_PAYMENT_USE_ID,ORDER_OF_PREFERENCE,START_DATE from IBY_PMT_INSTR_USES_ALL
2968: where instrument_id = l_bank_account_id
2969: and EXT_PMT_PARTY_ID = (select EXT_PAYER_ID from IBY_EXTERNAL_PAYERS_ALL
2970: where CUST_ACCOUNT_ID = p_customer_id
2971: and ACCT_SITE_USE_ID = p_customer_site_id);
2972:
2973: l_api_version NUMBER := 1.0;