APPS.GMS_COST_PLUS_EXTN dependencies on DUAL

Line 1484: from dual ;

1480: decode( p_doc_type, 'REQ', x_rec_award_exp_tot.req_burdenable_cost,
1481: 'PO', x_rec_award_exp_tot.po_burdenable_cost,
1482: 'ENC', x_rec_award_exp_tot.enc_burdenable_cost, 1 )
1483: into x_adj_allowed
1484: from dual ;
1485:
1486: IF g_debug = 'Y' THEN
1487: gms_error_pkg.gms_debug (g_error_procedure_name||':x_adj_allowed:'||x_adj_allowed,'C');
1488: END IF;

Line 1558: FROM dual ;

1554:
1555: IF x_adjustment_id IS NULL THEN
1556: select gms_adjustments_id_s.NEXTVAL
1557: INTO x_adjustment_id
1558: FROM dual ;
1559: END IF ;
1560:
1561: x_line_num := x_line_num + 1 ;
1562: x_rec_log.adjustment_id := x_adjustment_id ;

Line 1804: FROM dual ;

1800:
1801: IF x_adjustment_id IS NULL THEN
1802: select gms_adjustments_id_s.NEXTVAL
1803: INTO x_adjustment_id
1804: FROM dual ;
1805: END IF ;
1806:
1807: x_line_num := NVL(x_line_num,0) + 1 ; -- BRC.1
1808: x_rec_log.adjustment_id := x_adjustment_id ;

Line 1965: select gms_adjustments_id_s.NEXTVAL into l_calc_sequence from dual;

1961:
1962: x_tot_raw := x_tot_raw + p_amount ;
1963: x_tot_burden:= x_tot_burden + p_burden ;
1964:
1965: select gms_adjustments_id_s.NEXTVAL into l_calc_sequence from dual;
1966:
1967: UPDATE gms_bc_packets
1968: set burdenable_raw_cost = p_burden,
1969: burden_calculation_seq = l_calc_sequence

Line 2542: FROM dual ;

2538:
2539: IF x_adjustment_id IS NULL THEN
2540: select gms_adjustments_id_s.NEXTVAL
2541: INTO x_adjustment_id
2542: FROM dual ;
2543: END IF ;
2544:
2545: x_line_num := x_line_num + 1 ;
2546: x_rec_log.adjustment_id := x_adjustment_id ;

Line 2849: FROM dual ;

2845:
2846: IF x_adjustment_id IS NULL THEN
2847: select gms_adjustments_id_s.NEXTVAL
2848: INTO x_adjustment_id
2849: FROM dual ;
2850: END IF ;
2851: x_line_num := NVL(x_line_num,0) + 1 ;
2852:
2853: x_rec_log.adjustment_id := x_adjustment_id ;

Line 2957: FROM dual ;

2953:
2954: IF x_adjustment_id IS NULL THEN
2955: select gms_adjustments_id_s.NEXTVAL
2956: INTO x_adjustment_id
2957: FROM dual ;
2958: END IF ;
2959: x_line_num := NVL(x_line_num,0) + 1 ;
2960:
2961: x_rec_log.adjustment_id := x_adjustment_id ;

Line 3516: FROM dual ;

3512:
3513: -- A.4 Get burden_calculation_seq (adjustment_id) and set values (Common)
3514: select gms_adjustments_id_s.NEXTVAL
3515: INTO x_adjustment_id
3516: FROM dual ;
3517:
3518: x_rec_log.packet_id := p_packet_id ;
3519: x_rec_log.award_id := x.award_id;
3520: x_rec_log.expenditure_type := x.expenditure_type ;

Line 3814: from dual where exists

3810:
3811: Begin
3812:
3813: Select 1 into l_count
3814: from dual where exists
3815: (select 1 from gms_bc_packets bcp
3816: where bcp.packet_id = p_packet_id
3817: and bcp.award_id = p_award_id
3818: and bcp.expenditure_type = p_expenditure_type

Line 3939: select 'A' into g_actual_flag from dual where exists

3935: If p_mode in ('U','C','E') then
3936: g_actual_flag := 'E';
3937: Elsif p_mode in ('R') then
3938: Begin
3939: select 'A' into g_actual_flag from dual where exists
3940: (select 1 from gms_bc_packets where packet_id = x_packet_id
3941: and document_type = 'EXP');
3942: Exception
3943: When no_data_found then