APPS.AR_IREC_PAYMENTS dependencies on DUAL

Line 145: FROM dual;

141: arp_util.debug('ar_irec_payments_pkg.is_credit_card_number_valid()+0');
142:
143: SELECT lengthb(p_credit_card_number)
144: INTO l_len_credit_card_num
145: FROM dual;
146:
147: FOR i in 1..l_len_credit_card_num LOOP
148: SELECT to_number(substrb(p_credit_card_number,i,1))
149: INTO l_stripped_num_table(i)

Line 150: FROM dual;

146:
147: FOR i in 1..l_len_credit_card_num LOOP
148: SELECT to_number(substrb(p_credit_card_number,i,1))
149: INTO l_stripped_num_table(i)
150: FROM dual;
151: END LOOP;
152: l_actual_cc_check_digit := l_stripped_num_table(l_len_credit_card_num);
153:
154: FOR i in 1..l_len_credit_card_num-1 LOOP

Line 1722: from dual;

1718:
1719: CURSOR current_date_cur IS
1720: select to_char(to_number(to_char(sysdate,'MM'))) current_month,
1721: to_char(sysdate,'YYYY') current_year
1722: from dual;
1723:
1724: current_date_rec current_date_cur%ROWTYPE;
1725:
1726: BEGIN

Line 4782: from dual;

4778: l_payee_rec.org_id := mo_global.get_current_org_id ;
4779:
4780: select 'ARI_'||ar_payment_server_ord_num_s.nextval
4781: into l_payment_server_order_num
4782: from dual;
4783:
4784: l_trxn_rec.Originating_Application_Id:=222;
4785: l_trxn_rec.Order_Id:=l_payment_server_order_num;
4786: l_trxn_rec.Instrument_Security_Code :=l_cvv2;