APPS.GMS_POR_API dependencies on DUAL

Line 271: from dual

267: WHERE enabled ='Y' ;
268:
269: cursor valid_award_csr is
270: select 'Y'
271: from dual
272: where exists
273: (select 1
274: from gms_awards
275: where award_number = X_award_number

Line 1122: FROM DUAL;

1118: l_source_type_code po_requisition_lines_all.source_type_code%type;
1119:
1120: CURSOR c_next_header_id IS
1121: SELECT gms_packet_header_id_s.NEXTVAL
1122: FROM DUAL;
1123:
1124: CURSOR c_next_dist_id IS
1125: SELECT gms_packet_dist_id_s.NEXTVAL
1126: FROM DUAL;

Line 1126: FROM DUAL;

1122: FROM DUAL;
1123:
1124: CURSOR c_next_dist_id IS
1125: SELECT gms_packet_dist_id_s.NEXTVAL
1126: FROM DUAL;
1127:
1128: CURSOR c_awd_dist_status IS
1129: SELECT awd.dist_status
1130: FROM gms_distributions awd