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_AWARDS_BOUNDARY_DATES_CHK dependencies on GMS_RESOURCE_ASSIGNMENTS

Line 11: gms_resource_assignments pra,

7:
8: CURSOR budget_lines_csr IS
9: SELECT 1
10: FROM gms_budget_versions pbv,
11: gms_resource_assignments pra,
12: gms_budget_lines pbl
13: WHERE pbv.budget_version_id = pra.budget_version_id
14: AND pbv.award_id = P_AWARD_ID
15: AND pra.resource_assignment_id = pbl.resource_assignment_id

Line 226: gms_resource_assignments pra,

222:
223: CURSOR budget_lines_csr IS
224: SELECT 1
225: FROM gms_budget_versions pbv,
226: gms_resource_assignments pra,
227: gms_budget_lines pbl
228: WHERE pbv.budget_version_id = pra.budget_version_id
229: AND pbv.award_id = P_AWARD_ID
230: AND pra.resource_assignment_id = pbl.resource_assignment_id

Line 467: from gms_resource_assignments gra,

463: select gra.resource_list_member_id,
464: gra.task_id,
465: gbl.start_date,
466: gbl.end_date
467: from gms_resource_assignments gra,
468: gms_budget_lines gbl
469: where gra.resource_assignment_id = gbl.resource_assignment_id
470: and gra.budget_version_id = p_budget_version_id;
471:

Line 530: gms_resource_assignments pra,

526:
527: CURSOR budget_lines_csr IS
528: SELECT 1
529: FROM gms_budget_versions pbv,
530: gms_resource_assignments pra,
531: gms_budget_lines pbl
532: WHERE pbv.budget_version_id = pra.budget_version_id
533: AND pbv.project_id = P_PROJECT_ID
534: AND pra.resource_assignment_id = pbl.resource_assignment_id

Line 640: gms_resource_assignments pra,

636: FROM DUAL
637: WHERE EXISTS
638: ( SELECT 1
639: FROM gms_budget_versions pbv,
640: gms_resource_assignments pra,
641: gms_budget_lines pbl
642: WHERE pbv.budget_version_id = pra.budget_version_id
643: AND pbv.project_id = P_PROJECT_ID
644: AND pra.resource_assignment_id = pbl.resource_assignment_id

Line 789: gms_resource_assignments pra,

785:
786: CURSOR budget_lines_csr IS
787: SELECT 1
788: FROM gms_budget_versions pbv,
789: gms_resource_assignments pra,
790: gms_budget_lines pbl
791: WHERE pbv.budget_version_id = pra.budget_version_id
792: AND pbv.project_id = P_PROJECT_ID
793: AND pra.resource_assignment_id = pbl.resource_assignment_id