APPS.IBY_EVAL_RISKY_INSTR_PKG dependencies on IBY_CREDITCARD

Line 23: lx_cc_number iby_creditcard.ccnumber%TYPE;

19:
20: is
21: l_count number;
22: l_ccnumber varchar2(30);
23: lx_cc_number iby_creditcard.ccnumber%TYPE;
24: lx_return_status VARCHAR2(1);
25: lx_msg_count NUMBER;
26: lx_msg_data VARCHAR2(200);
27: l_cc_hash1 iby_irf_risky_instr.cc_number_hash1%TYPE;

Line 29: l_cc_strip_number iby_creditcard.ccnumber%TYPE;

25: lx_msg_count NUMBER;
26: lx_msg_data VARCHAR2(200);
27: l_cc_hash1 iby_irf_risky_instr.cc_number_hash1%TYPE;
28: l_cc_hash2 iby_irf_risky_instr.cc_number_hash2%TYPE;
29: l_cc_strip_number iby_creditcard.ccnumber%TYPE;
30: begin
31: --dbms_output.put_line('ccnumber = '||i_ccnumber);
32: --dbms_output.put_line('instrid = '||to_char(i_instrid));
33: if (i_ccnumber is null and i_instrid <> -99) then

Line 35: from iby_creditcard

31: --dbms_output.put_line('ccnumber = '||i_ccnumber);
32: --dbms_output.put_line('instrid = '||to_char(i_instrid));
33: if (i_ccnumber is null and i_instrid <> -99) then
34: select ccnumber into l_ccnumber
35: from iby_creditcard
36: where instrid = i_instrid;
37: else
38: l_ccnumber := i_ccnumber;
39: end if;