APPS.AP_AUTOSELECT_PKG dependencies on DUAL

Line 608: FROM sys.dual;

604: p_checkrun_id,
605: l_pay_currency_code,
606: 'N'
607: --bug12349626
608: FROM sys.dual;
609:
610: END IF;
611:
612: END LOOP;

Line 1294: from dual

1290: 5,
1291: 5,
1292: sysdate,
1293: l_org_id
1294: from dual
1295: where fv_econ_benf_disc.ebd_check(p_payment_process_request_name, l_invoice_id,
1296: p_check_date, l_due_date, l_discount_amount_available, l_discount_date) = 'N';
1297:
1298:

Line 1974: from dual;

1970:
1971:
1972: select ap_inv_selection_criteria_s.nextval
1973: into p_checkrun_id
1974: from dual;
1975:
1976:
1977:
1978: l_debug_info := 'insert into ap_inv_selection_criteria_all';

Line 3164: ' FROM sys.dual '||

3160: -- Bug 7265013 starts
3161: /* Bug 13901772
3162: ' AND EXISTS ( '||
3163: ' SELECT 1 '||
3164: ' FROM sys.dual '||
3165: ' WHERE AP_INVOICES_PKG.get_wfapproval_status(ai.invoice_id, ai.org_id) in '||
3166: ' (''NOT REQUIRED'',''WFAPPROVED'',''MANUALLY APPROVED'') '||
3167: ' ) '||
3168: */

Line 3981: ' FROM sys.dual '||

3977: ' :p_zero_inv_allowed = ''Y'') '||
3978: -- Bug 7265013 starts
3979: /*' AND EXISTS ( '||
3980: ' SELECT 1 '||
3981: ' FROM sys.dual '||
3982: ' WHERE AP_INVOICES_PKG.get_wfapproval_status(ai.invoice_id, ai.org_id) in '||
3983: ' (''NOT REQUIRED'',''WFAPPROVED'',''MANUALLY APPROVED'') '||
3984: ' ) '|| */
3985: /* Bug 13901772 */