APPS.OE_VERSION_COMP dependencies on IBY_CREDITCARD_H

Line 21238: FROM iby_creditcard_h

21234: IF p_is_card_history1 = 'Y' THEN
21235: BEGIN
21236: SELECT CHNAME
21237: INTO l_attribute_value1
21238: FROM iby_creditcard_h
21239: WHERE card_history_change_id = p_instrument_id1;
21240: EXCEPTION WHEN NO_DATA_FOUND THEN
21241: null;
21242: END;

Line 21259: FROM iby_creditcard_h

21255: IF p_is_card_history2 = 'Y' THEN
21256: BEGIN
21257: SELECT CHNAME
21258: INTO l_attribute_value2
21259: FROM iby_creditcard_h
21260: WHERE card_history_change_id = p_instrument_id2;
21261: EXCEPTION WHEN NO_DATA_FOUND THEN
21262: null;
21263: END;

Line 21281: FROM iby_creditcard_h

21277: IF p_is_card_history1 = 'Y' THEN
21278: BEGIN
21279: SELECT card_issuer_code
21280: INTO l_attribute_value1
21281: FROM iby_creditcard_h
21282: WHERE card_history_change_id = p_instrument_id1;
21283: EXCEPTION WHEN NO_DATA_FOUND THEN
21284: null;
21285: END;

Line 21301: FROM iby_creditcard_h

21297: IF p_is_card_history2 = 'Y' THEN
21298: BEGIN
21299: SELECT card_issuer_code
21300: INTO l_attribute_value2
21301: FROM iby_creditcard_h
21302: WHERE card_history_change_id = p_instrument_id2;
21303: EXCEPTION WHEN NO_DATA_FOUND THEN
21304: null;
21305: END;

Line 21322: FROM iby_creditcard_h

21318: IF p_is_card_history1 = 'Y' THEN
21319: BEGIN
21320: SELECT expirydate
21321: INTO l_attribute_value1
21322: FROM iby_creditcard_h
21323: WHERE card_history_change_id = p_instrument_id1;
21324: EXCEPTION WHEN NO_DATA_FOUND THEN
21325: null;
21326: END;

Line 21343: FROM iby_creditcard_h

21339: IF p_is_card_history2 = 'Y' THEN
21340: BEGIN
21341: SELECT expirydate
21342: INTO l_attribute_value2
21343: FROM iby_creditcard_h
21344: WHERE card_history_change_id = p_instrument_id2;
21345: EXCEPTION WHEN NO_DATA_FOUND THEN
21346: null;
21347: END;