DBA Data[Home] [Help]

APPS.GMS_POR_API2 dependencies on DUAL

Line 53: FROM DUAL;

49: and b.project_type = pt.project_type
50: and pt.sponsored_flag = 'Y' ;
51: CURSOR c_next_header_id IS
52: SELECT gms_packet_header_id_s.NEXTVAL
53: FROM DUAL;
54:
55: CURSOR c_next_dist_id IS
56: SELECT gms_packet_dist_id_s.NEXTVAL
57: FROM DUAL;

Line 57: FROM DUAL;

53: FROM DUAL;
54:
55: CURSOR c_next_dist_id IS
56: SELECT gms_packet_dist_id_s.NEXTVAL
57: FROM DUAL;
58:
59: CURSOR c_awd_dist_status IS
60: SELECT awd.dist_status
61: FROM gms_distributions awd