DBA Data[Home] [Help]

APPS.GMS_BUDGET_BALANCE dependencies on DUAL

Line 1995: SELECT 1 into x_dummy from dual

1991: -- be picked from GMS_BALANCES since it will no longer be in
1992: -- GMS_BC_PACKETS.
1993:
1994: begin
1995: SELECT 1 into x_dummy from dual
1996: where exists (select 'x'
1997: FROM gms_bc_packets
1998: WHERE project_id = x_project_id
1999: AND award_id = x_award_id

Line 2052: select gl_bc_packets_s.nextval into x_packet_id from dual;

2048: x_e_stage := '500';
2049: IF L_DEBUG = 'Y' THEN
2050: gms_error_pkg.gms_debug('gms_budget_balance -5','C');
2051: END IF;
2052: select gl_bc_packets_s.nextval into x_packet_id from dual;
2053: -- Create raw transactions in GMS_BC_PACKETS
2054: x_e_stage := '600';
2055: IF L_DEBUG = 'Y' THEN
2056: gms_error_pkg.gms_debug('gms_budget_balance -6','C');