APPS.OE_VERSION_COMP dependencies on IBY_CREDITCARD_H

Line 5761: from iby_creditcard_h

5757: when others then
5758: begin
5759: select encrypted
5760: into l_encrypted
5761: from iby_creditcard_h
5762: where card_history_change_id=p_prior_rec.cc_instrument_id;
5763: exception
5764: when others then
5765: null;

Line 5780: from iby_creditcard_h

5776: --l_encrypted1:=null;
5777: begin
5778: select encrypted
5779: into l_encrypted1
5780: from iby_creditcard_h
5781: where card_history_change_id=p_curr_rec.cc_instrument_id;
5782: exception
5783: when others then
5784: null;

Line 5849: from iby_creditcard_h

5845: --l_encrypted:=null;
5846: begin
5847: select encrypted
5848: into l_encrypted
5849: from iby_creditcard_h
5850: where card_history_change_id=p_next_rec.cc_instrument_id;
5851: exception
5852: when others then
5853: null;

Line 5868: from iby_creditcard_h

5864: --l_encrypted1:=null;
5865: begin
5866: select encrypted
5867: into l_encrypted1
5868: from iby_creditcard_h
5869: where card_history_change_id=p_curr_rec.cc_instrument_id;
5870: exception
5871: when others then
5872: null;

Line 21788: FROM iby_creditcard_h

21784: IF p_is_card_history1 = 'Y' THEN
21785: BEGIN
21786: SELECT CHNAME
21787: INTO l_attribute_value1
21788: FROM iby_creditcard_h
21789: WHERE card_history_change_id = p_instrument_id1;
21790: EXCEPTION WHEN NO_DATA_FOUND THEN
21791: null;
21792: END;

Line 21809: FROM iby_creditcard_h

21805: IF p_is_card_history2 = 'Y' THEN
21806: BEGIN
21807: SELECT CHNAME
21808: INTO l_attribute_value2
21809: FROM iby_creditcard_h
21810: WHERE card_history_change_id = p_instrument_id2;
21811: EXCEPTION WHEN NO_DATA_FOUND THEN
21812: null;
21813: END;

Line 21831: FROM iby_creditcard_h

21827: IF p_is_card_history1 = 'Y' THEN
21828: BEGIN
21829: SELECT card_issuer_code
21830: INTO l_attribute_value1
21831: FROM iby_creditcard_h
21832: WHERE card_history_change_id = p_instrument_id1;
21833: EXCEPTION WHEN NO_DATA_FOUND THEN
21834: null;
21835: END;

Line 21851: FROM iby_creditcard_h

21847: IF p_is_card_history2 = 'Y' THEN
21848: BEGIN
21849: SELECT card_issuer_code
21850: INTO l_attribute_value2
21851: FROM iby_creditcard_h
21852: WHERE card_history_change_id = p_instrument_id2;
21853: EXCEPTION WHEN NO_DATA_FOUND THEN
21854: null;
21855: END;

Line 21880: from iby_creditcard_h

21876: --l_encrypted:=null;
21877: begin
21878: select encrypted
21879: into l_encrypted
21880: from iby_creditcard_h
21881: where card_history_change_id=p_instrument_id1;
21882: exception
21883: when others then
21884: null;

Line 21894: FROM iby_creditcard_h

21890: --IF NOT iby_cc_security_pub.encryption_enabled() THEN
21891: IF nvl(l_encrypted,'N') <> 'A' THEN
21892: SELECT expirydate
21893: INTO l_attribute_value1
21894: FROM iby_creditcard_h
21895: WHERE card_history_change_id = p_instrument_id1;
21896: ELSE
21897: select credit_card_expiration_date
21898: INTO l_attribute_value1

Line 21934: from iby_creditcard_h

21930: --l_encrypted:=null;
21931: begin
21932: select encrypted
21933: into l_encrypted
21934: from iby_creditcard_h
21935: where card_history_change_id=p_instrument_id2;
21936: exception
21937: when others then
21938: null;

Line 21948: FROM iby_creditcard_h

21944: --IF NOT iby_cc_security_pub.encryption_enabled() THEN
21945: IF nvl(l_encrypted,'N') <> 'A' THEN
21946: SELECT expirydate
21947: INTO l_attribute_value2
21948: FROM iby_creditcard_h
21949: WHERE card_history_change_id = p_instrument_id2;
21950: ELSE
21951: select credit_card_expiration_date
21952: INTO l_attribute_value2