APPS.AR_ARXCCS_XMLP_PKG dependencies on DUAL

Line 3035: from dual;

3031: /*srw.message(300,'DEBUG: related currencies :'||CP_related_currencies);*/null;
3032:
3033: Select instr( CP_related_currencies, trx_cur)
3034: INTO present
3035: from dual;
3036: if present <> 0 then
3037: /*srw.message(300,'DEBUG: trx_curr :'||trx_cur);*/null;
3038:
3039: /*srw.message(300,'DEBUG: cp_limit_currency :'||CP_limit_currency);*/null;

Line 3141: from dual;

3137:
3138:
3139: Select instr( related_currencies, trx_cur2)
3140: INTO present
3141: from dual;
3142: /*srw.message(300, 'DEBUG: present : '|| to_char(present));*/null;
3143:
3144:
3145: if present <> 0 then

Line 3316: FROM DUAL;

3312: FOR trx_rec IN ps_trx
3313: LOOP
3314: SELECT instr(related_currencies,trx_rec.invoice_currency_code)
3315: INTO curr_exists
3316: FROM DUAL;
3317: IF curr_exists <> 0 THEN
3318: trx_curr := trx_rec.invoice_currency_code;
3319:
3320:

Line 3434: from dual;

3430:
3431:
3432: Select instr( related_currencies, org_trx_cur)
3433: INTO present
3434: from dual;
3435: /*srw.message(300, 'DEBUG: present : '|| to_char(present));*/null;
3436:
3437:
3438: if present <> 0 then

Line 3777: FROM DUAL;

3773: FOR trx_rec IN ps_trx
3774: LOOP
3775: SELECT instr(related_currencies,trx_rec.invoice_currency_code)
3776: INTO curr_exists
3777: FROM DUAL;
3778: IF curr_exists <> 0 THEN
3779: trx_curr := trx_rec.invoice_currency_code;
3780:
3781: l_loop:='Y';