APPS.OE_VERSION_COMP dependencies on IBY_CREDITCARD

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 21247: FROM iby_creditcard

21243: ELSE
21244: BEGIN
21245: SELECT CHNAME
21246: INTO l_attribute_value1
21247: FROM iby_creditcard
21248: WHERE instrid = p_instrument_id1;
21249: EXCEPTION WHEN NO_DATA_FOUND THEN
21250: null;
21251: 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 21268: FROM iby_creditcard

21264: ELSE
21265: BEGIN
21266: SELECT CHNAME
21267: INTO l_attribute_value2
21268: FROM iby_creditcard
21269: WHERE instrid = p_instrument_id2;
21270: EXCEPTION WHEN NO_DATA_FOUND THEN
21271: null;
21272: 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 21290: FROM iby_creditcard

21286: ELSE
21287: BEGIN
21288: SELECT card_issuer_code
21289: INTO l_attribute_value1
21290: FROM iby_creditcard
21291: WHERE instrid = p_instrument_id1;
21292: EXCEPTION WHEN NO_DATA_FOUND THEN
21293: null;
21294: 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 21310: FROM iby_creditcard

21306: ELSE
21307: BEGIN
21308: SELECT card_issuer_code
21309: INTO l_attribute_value2
21310: FROM iby_creditcard
21311: WHERE instrid = p_instrument_id2;
21312: EXCEPTION WHEN NO_DATA_FOUND THEN
21313: null;
21314: 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 21332: FROM iby_creditcard

21328: ELSE
21329: BEGIN
21330: SELECT expirydate
21331: INTO l_attribute_value1
21332: FROM iby_creditcard
21333: WHERE instrid = p_instrument_id1;
21334: EXCEPTION WHEN NO_DATA_FOUND THEN
21335: null;
21336: 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;

Line 21352: FROM iby_creditcard

21348: ELSE
21349: BEGIN
21350: SELECT expirydate
21351: INTO l_attribute_value2
21352: FROM iby_creditcard
21353: WHERE instrid = p_instrument_id2;
21354: EXCEPTION WHEN NO_DATA_FOUND THEN
21355: null;
21356: END;