DBA Data[Home] [Help]

APPS.ARP_EXT_BANK_PKG dependencies on DUAL

Line 33: FROM dual;

29: END IF;
30:
31: SELECT lengthb(p_credit_card_num)
32: INTO len_credit_card_num
33: FROM dual;
34:
35: FOR i in 1..len_credit_card_num LOOP
36: SELECT substrb(p_credit_card_num,i,1)
37: INTO l_cc_num_char(i)

Line 38: FROM dual;

34:
35: FOR i in 1..len_credit_card_num LOOP
36: SELECT substrb(p_credit_card_num,i,1)
37: INTO l_cc_num_char(i)
38: FROM dual;
39:
40: IF ( (l_cc_num_char(i) >= '0') and
41: (l_cc_num_char(i) <= '9')
42: )

Line 1036: dual;

1032: RA_CUST_RECEIPT_METHODS_S.NEXTVAL
1033: INTO
1034: l_cust_pay_method_id
1035: FROM
1036: dual;
1037: --
1038: IF check_primary_method_exists(p_customer_id=>p_customer_id,
1039: p_site_use_id=>p_site_use_id,
1040: p_as_of_date=>NVL(p_as_of_date, TRUNC(SYSDATE))) THEN