[Home] [Help]
1256: bank.bank_id bank_party_id,
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,
1309: NULL bank_party_id,
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,
1778: WHERE cust_account_id = p_customer_id;
1779:
1780: CURSOR object_version_cur(p_party_id IN NUMBER, p_preference_code IN VARCHAR2) IS
1781: SELECT party_preference_id, object_version_number
1782: FROM hz_party_preferences
1783: WHERE party_id = p_party_id
1784: AND category = 'LAST_USED_PAYMENT_INSTRUMENT'
1785: AND preference_code = p_preference_code;
1786: