APPS.PSP_PREGEN dependencies on GMS_AWARDS

Line 1445: FROM gms_awards_basic_v

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

Line 1462: from gms_awards

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

Line 1712: FROM gms_awards

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