APPS.OE_AUDIT_HISTORY_PVT dependencies on IBY_CREDITCARD_H

Line 2257: FROM iby_creditcard_h

2253: IF p_attribute_id in (46, 49) AND l_old_cc_number IS NULL AND l_old_cc_code IS NULL THEN
2254: BEGIN
2255: SELECT instrid
2256: INTO l_old_instrument_id
2257: FROM iby_creditcard_h
2258: WHERE card_history_change_id = l_old_instrument_id;
2259: EXCEPTION WHEN NO_DATA_FOUND THEN
2260: l_old_instrument_id := null;
2261: END;

Line 2270: FROM iby_creditcard_h

2266:
2267: BEGIN
2268: SELECT instrid
2269: INTO l_new_instrument_id
2270: FROM iby_creditcard_h
2271: WHERE card_history_change_id = l_new_instrument_id;
2272: EXCEPTION WHEN NO_DATA_FOUND THEN
2273: l_new_instrument_id := null;
2274: END;

Line 2349: || ' from iby_creditcard_h'

2345: -- AND (l_old_cc_code is null and l_new_cc_code is null)
2346: -- THEN
2347: l_old_sql_stmt := 'select '
2348: || l_column_name
2349: || ' from iby_creditcard_h'
2350: || ' where card_history_change_id = :x ';
2351: ELSE
2352: l_old_sql_stmt := 'select '
2353: || l_column_name

Line 2362: || ' from iby_creditcard_h'

2358:
2359: IF (l_new_cc_code is null and l_new_cc_code is null) THEN
2360: l_new_sql_stmt := 'select '
2361: || l_column_name
2362: || ' from iby_creditcard_h'
2363: || ' where card_history_change_id = :x ';
2364: ELSE
2365: l_new_sql_stmt := 'select '
2366: || l_column_name

Line 2421: || ' from iby_creditcard_h'

2417:
2418: IF p_instr_flag = 'N' THEN
2419: l_sql_stmt := 'select '
2420: || l_column_name
2421: || ' from iby_creditcard_h'
2422: || ' where card_history_change_id = :x ';
2423:
2424: ELSE
2425: l_sql_stmt := 'select '