eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMS_POR_API2 dependencies on DUAL

Line 59: FROM DUAL;

55: and b.project_type = pt.project_type
56: and pt.sponsored_flag = 'Y' ;
57: CURSOR c_next_header_id IS
58: SELECT gms_packet_header_id_s.NEXTVAL
59: FROM DUAL;
60:
61: CURSOR c_next_dist_id IS
62: SELECT gms_packet_dist_id_s.NEXTVAL
63: FROM DUAL;

Line 63: FROM DUAL;

59: FROM DUAL;
60:
61: CURSOR c_next_dist_id IS
62: SELECT gms_packet_dist_id_s.NEXTVAL
63: FROM DUAL;
64:
65: CURSOR c_awd_dist_status IS
66: SELECT awd.dist_status
67: FROM gms_distributions awd