APPS.OKS_QA_DATA_INTEGRITY dependencies on DUAL

Line 975: FROM dual;

971: BEGIN
972:
973: SELECT length(p_cc_num_stripped)
974: INTO l_len_credit_card_num
975: FROM dual;
976:
977: FOR i IN 1..l_len_credit_card_num LOOP
978: SELECT to_number(substr(p_cc_num_stripped, i, 1))
979: INTO l_stripped_num_table(i)

Line 980: FROM dual;

976:
977: FOR i IN 1..l_len_credit_card_num LOOP
978: SELECT to_number(substr(p_cc_num_stripped, i, 1))
979: INTO l_stripped_num_table(i)
980: FROM dual;
981: END LOOP;
982: l_actual_cc_check_digit := l_stripped_num_table(l_len_credit_card_num);
983:
984: FOR i IN 1..l_len_credit_card_num - 1 LOOP