[Home] [Help]
992: END IF;
993: ELSE
994: WRITE_DEBUG_AND_LOG('In BA expiration date update');
995: -- Modified for Bug#16262617 : Start
996: SELECT PARTY_ID INTO l_party_id FROM HZ_CUST_ACCOUNTS WHERE CUST_ACCOUNT_ID = p_customer_id;
997: -- Modified for Bug#16420473 :Start
998: OPEN instr_details(p_bank_account_id,l_party_id,l_customer_site_id);
999: IF (instr_details%NOTFOUND) THEN
1000: select org_id,instr_assignment_id,assignment_start_date,acct_site_use_id
1255: u.instrument_payment_use_id instr_assignment_id,
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,
1308: c.INSTR_ASSIGNMENT_ID,
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,
1358: bank.bank_id bank_party_id,
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,
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,
1424: hz_party_sites hps,
1425: hz_locations loc,
1426: fnd_territories_vl terr
1773: l_msg_data VARCHAR(2000);
1774:
1775: CURSOR customer_party_cur IS
1776: SELECT party_id
1777: FROM hz_cust_accounts
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
2324: ct.PAYING_SITE_USE_ID,
2325: ( decode( nvl(ps.AMOUNT_DUE_ORIGINAL,0),0,1,(ps.AMOUNT_DUE_ORIGINAL/abs(ps.AMOUNT_DUE_ORIGINAL)) ) *abs(nvl(ps.amount_in_dispute,0)) ) dispute_amt
2326: FROM AR_PAYMENT_SCHEDULES ps,
2327: RA_CUSTOMER_TRX ct,
2328: HZ_CUST_ACCOUNTS acct,
2329: RA_TERMS trm
2330: WHERE ps.CLASS IN ('INV', 'DM', 'CB', 'DEP')
2331: AND ps.customer_trx_id = ct.customer_trx_id
2332: AND acct.cust_account_id = ps.customer_id
2618: 0 PAYING_SITE_USE_ID,
2619: 0 dispute_amt
2620: FROM AR_PAYMENT_SCHEDULES ps,
2621: RA_CUSTOMER_TRX_ALL ct,
2622: HZ_CUST_ACCOUNTS acct,
2623: RA_TERMS trm
2624: WHERE ps.customer_id = p_customer_id
2625: AND ( ps.CLASS = 'CM'
2626: OR
4434:
4435: l_cvv_use VARCHAR2(100);
4436: l_billing_addr_use VARCHAR2(100);
4437: CURSOR party_id_cur IS
4438: SELECT PARTY_ID FROM HZ_CUST_ACCOUNTS WHERE CUST_ACCOUNT_ID = p_customer_id;
4439:
4440: party_id_rec party_id_cur%ROWTYPE;
4441:
4442: p_site_use_id_srvc_chrg NUMBER;
5812: decode(ps.customer_site_use_id, null, -1,ps.customer_site_use_id) as CUSTOMER_SITE_USE_ID,
5813: (decode( nvl(ps.AMOUNT_DUE_ORIGINAL,0),0,1,(ps.AMOUNT_DUE_ORIGINAL/abs(ps.AMOUNT_DUE_ORIGINAL)) ) *abs(nvl(ps.amount_in_dispute,0)) )
5814: FROM AR_PAYMENT_SCHEDULES ps,
5815: RA_CUSTOMER_TRX_ALL ct,
5816: HZ_CUST_ACCOUNTS acct,
5817: RA_TERMS trm
5818: WHERE ps.payment_schedule_id = p_payment_schedule_id
5819: AND ps.CLASS IN ('INV', 'DM', 'GUAR', 'CB', 'DEP', 'CM', 'PMT' ) -- CCA - hikumar
5820: AND ps.customer_trx_id = ct.customer_trx_id(+)