APPS.OE_PAYMENT_DATA_MIGRATION_UTIL dependencies on DUAL

Line 66: FROM dual;

62: IF p_credit_card_num IS NOT NULL THEN
63:
64: SELECT lengthb(p_credit_card_num)
65: INTO len_credit_card_num
66: FROM dual;
67:
68: FOR i in 1..len_credit_card_num LOOP
69: SELECT substrb(p_credit_card_num,i,1)
70: INTO l_cc_num_char(i)

Line 71: FROM dual;

67:
68: FOR i in 1..len_credit_card_num LOOP
69: SELECT substrb(p_credit_card_num,i,1)
70: INTO l_cc_num_char(i)
71: FROM dual;
72:
73: IF ( (l_cc_num_char(i) >= '0') and (l_cc_num_char(i) <= '9')) THEN
74: -- Numeric digit. Add to stripped_number and table.
75: p_stripped_cc_num := p_stripped_cc_num || l_cc_num_char(i);