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 881: from dual;

877: 'INV', 'USG',
878: 'WIP', 'USG',
879: 'VI', 'VI')
880: into l_system_linkage
881: from dual;
882:
883: -- Call fundscheck in 'X' mode. Internally this is treated same as
884: -- 'R' by fundscheck with some flow changes.
885:

Line 1666: FROM DUAL

1662: document_type = 'EXP',
1663: actual_flag = 'A'
1664: where packet_id = g_packet_id
1665: AND bc_packet_id NOT IN (SELECT l_ap_bc_pkt_id
1666: FROM DUAL
1667: UNION ALL
1668: SELECT bc_packet_id
1669: FROM gms_bc_packets
1670: WHERE parent_bc_packet_id = l_ap_bc_pkt_id

Line 1682: FROM DUAL

1678: gbp1.document_type = 'EXP',
1679: gbp1.actual_flag = 'A'
1680: where gbp1.packet_id = g_packet_id
1681: AND gbp1.bc_packet_id NOT IN (SELECT l_ap_bc_pkt_id
1682: FROM DUAL
1683: UNION ALL
1684: SELECT gbp2.bc_packet_id
1685: FROM gms_bc_packets gbp2
1686: WHERE gbp2.parent_bc_packet_id = l_ap_bc_pkt_id

Line 2049: from dual

2045: g_error_stage := 'Populate concurrency table...';
2046: begin
2047: select '1'
2048: into l_exists
2049: from dual
2050: where exists (select '1' from gms_concurrency_control
2051: where process_name = 'GMSFCSYS'
2052: and request_id = g_request_id);
2053: exception

Line 2258: FROM DUAL;

2254: end; -- end changes for bug 7364172
2255:
2256: SELECT gms_bc_packet_arrival_order_s.NEXTVAL
2257: INTO x_arrival_order_seq
2258: FROM DUAL;
2259:
2260: g_error_stage := 'IN ARRIVAL ORD: INSRT';
2261:
2262: INSERT INTO gms_bc_packet_arrival_order

Line 2968: FROM DUAL;

2964: t_expenditure_category,
2965: t_revenue_category,
2966: t_adjusted_expenditure_item_id,
2967: t_nz_adj_flag
2968: FROM DUAL;
2969:
2970: END IF;
2971:
2972: