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_PREGEN dependencies on GMS_AWARDS

Line 1442: FROM gms_awards_basic_v

1438:
1439: /* Commented for bug 2054610
1440: CURSOR check_award_csr IS
1441: SELECT award_id
1442: FROM gms_awards_basic_v
1443: WHERE award_id = x_award_id
1444: and project_id = x_project_id
1445: and ROWNUM = 1; */
1446: /************************************************************************************

Line 1459: from gms_awards

1455: exists(select a.expenditure_type
1456: from gms_allowable_expenditures a
1457: where a.expenditure_type = et.expenditure_type
1458: and a.allowability_schedule_id = (select allowable_schedule_id
1459: from gms_awards
1460: where award_id = x_award_id))
1461: and et.expenditure_type = x_Expenditure_Type;
1462:
1463:

Line 1709: FROM gms_awards

1705: WHERE project_id = x_project_id;
1706: --
1707: SELECT nvl(end_date_active,l_payroll_end_date)
1708: INTO l_award_end_date
1709: FROM gms_awards
1710: WHERE award_id = x_award_id;
1711: --
1712: -- The following code added by PVELAMUR to fix bug 888089
1713: SELECT nvl(completion_date,l_payroll_end_date)