APPS.GMS_PA_COSTING_PKG dependencies on DUAL

Line 488: FROM DUAL

484:
485: -- Cursor to check if there exists any exchange rate variance for payment
486: CURSOR c_erv_exits IS
487: SELECT 'Y'
488: FROM DUAL
489: WHERE EXISTS (SELECT 1
490: FROM ap_invoice_payments Pay,
491: ap_invoices_all inv
492: WHERE pay.invoice_payment_id = g_xface_rec.cdl_system_reference4

Line 850: from dual;

846: 'INV', 'USG',
847: 'WIP', 'USG',
848: 'VI', 'VI')
849: into l_system_linkage
850: from dual;
851:
852: -- Call fundscheck in 'X' mode. Internally this is treated same as
853: -- 'R' by fundscheck with some flow changes.
854:

Line 1617: FROM DUAL

1613: document_type = 'EXP',
1614: actual_flag = 'A'
1615: where packet_id = g_packet_id
1616: AND bc_packet_id NOT IN (SELECT l_ap_bc_pkt_id
1617: FROM DUAL
1618: UNION ALL
1619: SELECT bc_packet_id
1620: FROM gms_bc_packets
1621: WHERE parent_bc_packet_id = l_ap_bc_pkt_id

Line 1994: from dual

1990: g_error_stage := 'Populate concurrency table...';
1991: begin
1992: select '1'
1993: into l_exists
1994: from dual
1995: where exists (select '1' from gms_concurrency_control
1996: where process_name = 'GMSFCSYS'
1997: and request_id = g_request_id);
1998: exception

Line 2178: FROM DUAL;

2174: FOR UPDATE;
2175:
2176: SELECT gms_bc_packet_arrival_order_s.NEXTVAL
2177: INTO x_arrival_order_seq
2178: FROM DUAL;
2179:
2180: g_error_stage := 'IN ARRIVAL ORD: INSRT';
2181:
2182: INSERT INTO gms_bc_packet_arrival_order

Line 2888: FROM DUAL;

2884: t_expenditure_category,
2885: t_revenue_category,
2886: t_adjusted_expenditure_item_id,
2887: t_nz_adj_flag
2888: FROM DUAL;
2889:
2890: END IF;
2891:
2892: