eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSD_RETURNS_UTIL dependencies on IBY_CREDITCARD

Line 2314: l_cc_number iby_creditcard.masked_cc_number%TYPE;

2310: END process_returns;
2311:
2312: FUNCTION get_credit_card(p_incident_id IN NUMBER) RETURN VARCHAR2
2313: IS
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

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