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.PSP_GENERAL dependencies on GMS_AWARDS_ALL

Line 814: FROM gms_awards_all -- Bug 6908158

810: WHERE project_id = p_project_id;
811:
812: SELECT nvl(end_date_active,p_payroll_end_date)
813: INTO l_award_end_date
814: FROM gms_awards_all -- Bug 6908158
815: WHERE award_id = p_award_id;
816:
817: SELECT nvl(completion_date,p_payroll_end_date)
818: INTO l_completion_date

Line 1121: from gms_awards_all --Bug 6908158

1117: BEGIN
1118: select nvl(preaward_date,start_date_active), end_date_active
1119: into
1120: x_award_start_date, x_award_end_date
1121: from gms_awards_all --Bug 6908158
1122: where award_id = p_award_id;
1123:
1124: IF (p_start_date NOT BETWEEN x_award_start_date AND
1125: NVL(x_award_end_date, fnd_date.canonical_to_date('4712/12/31'))) OR

Line 1407: FROM gms_awards_all

1403:
1404: FUNCTION get_award_number (p_award_id IN NUMBER) RETURN VARCHAR2 IS
1405: CURSOR award_number_cur IS
1406: SELECT award_number
1407: FROM gms_awards_all
1408: WHERE award_id = p_award_id;
1409:
1410: l_award_number VARCHAR2(200);
1411: