APPS.AR_IREC_PAYMENTS dependencies on DUAL

Line 139: FROM dual;

135: arp_util.debug('ar_irec_payments_pkg.is_credit_card_number_valid()+0');
136:
137: SELECT lengthb(p_credit_card_number)
138: INTO l_len_credit_card_num
139: FROM dual;
140:
141: FOR i in 1..l_len_credit_card_num LOOP
142: SELECT to_number(substrb(p_credit_card_number,i,1))
143: INTO l_stripped_num_table(i)

Line 144: FROM dual;

140:
141: FOR i in 1..l_len_credit_card_num LOOP
142: SELECT to_number(substrb(p_credit_card_number,i,1))
143: INTO l_stripped_num_table(i)
144: FROM dual;
145: END LOOP;
146: l_actual_cc_check_digit := l_stripped_num_table(l_len_credit_card_num);
147:
148: FOR i in 1..l_len_credit_card_num-1 LOOP

Line 1648: from dual;

1644:
1645: CURSOR current_date_cur IS
1646: select to_char(to_number(to_char(sysdate,'MM'))) current_month,
1647: to_char(sysdate,'YYYY') current_year
1648: from dual;
1649:
1650: current_date_rec current_date_cur%ROWTYPE;
1651:
1652: BEGIN

Line 4214: from dual;

4210: l_payee_rec.org_id := mo_global.get_current_org_id ;
4211:
4212: select 'ARI_'||ar_payment_server_ord_num_s.nextval
4213: into l_payment_server_order_num
4214: from dual;
4215:
4216: l_trxn_rec.Originating_Application_Id:=222;
4217: l_trxn_rec.Order_Id:=l_payment_server_order_num;
4218: l_trxn_rec.Instrument_Security_Code :=l_cvv2;