APPS.GMS_POR_API dependencies on DUAL

Line 328: from dual

324: WHERE enabled ='Y' ;
325:
326: cursor valid_award_csr is
327: select 'Y'
328: from dual
329: where exists
330: (select 1
331: from gms_awards
332: where award_number = X_award_number

Line 1348: FROM DUAL;

1344: l_source_type_code po_requisition_lines_all.source_type_code%type;
1345:
1346: CURSOR c_next_header_id IS
1347: SELECT gms_packet_header_id_s.NEXTVAL
1348: FROM DUAL;
1349:
1350: CURSOR c_next_dist_id IS
1351: SELECT gms_packet_dist_id_s.NEXTVAL
1352: FROM DUAL;

Line 1352: FROM DUAL;

1348: FROM DUAL;
1349:
1350: CURSOR c_next_dist_id IS
1351: SELECT gms_packet_dist_id_s.NEXTVAL
1352: FROM DUAL;
1353:
1354: CURSOR c_awd_dist_status IS
1355: SELECT awd.dist_status
1356: FROM gms_distributions awd