APPS.CSD_RETURNS_UTIL dependencies on CSD_CC_TRXN_XREF

Line 928: INSERT INTO csd_cc_trxn_xref(instrument_id,transaction_id,creation_date,created_by,last_updated_by,last_update_date,last_update_login)

924: END IF;
925: RAISE fnd_api.g_exc_error;
926: END IF;
927: x_authorized_flag := fnd_api.g_true;
928: INSERT INTO csd_cc_trxn_xref(instrument_id,transaction_id,creation_date,created_by,last_updated_by,last_update_date,last_update_login)
929: VALUES
930: (x_instr_id,
931: x_transaction_id,
932: sysdate,

Line 2269: UPDATE csd_cc_trxn_xref SET incident_id = x_incident_id

2265: END LOOP;
2266:
2267: IF p_cc_trxn_id IS NOT NULL AND p_cc_trxn_id > 0
2268: THEN
2269: UPDATE csd_cc_trxn_xref SET incident_id = x_incident_id
2270: WHERE transaction_id = p_cc_trxn_id;
2271: END IF;
2272:
2273: -- get the bill to site and ship to site ids.

Line 2318: FROM iby_creditcard cc, csd_cc_trxn_xref cctrxn

2314: l_cc_number iby_creditcard.masked_cc_number%TYPE;
2315: BEGIN
2316: SELECT masked_cc_number
2317: INTO l_cc_number
2318: FROM iby_creditcard cc, csd_cc_trxn_xref cctrxn
2319: WHERE cc.instrid = cctrxn.instrument_id
2320: AND cctrxn.incident_id = p_incident_id;
2321: RETURN l_cc_number;
2322: EXCEPTION