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_BUDGET_VERSIONS

Line 10: FROM gms_budget_versions pbv,

6: X_MESSAGE OUT NOCOPY VARCHAR2) IS
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

Line 234: FROM gms_budget_versions pbv,

230: X_MESSAGE OUT NOCOPY VARCHAR2) IS
231:
232: CURSOR budget_lines_csr IS
233: SELECT 1
234: FROM gms_budget_versions pbv,
235: gms_resource_assignments pra,
236: gms_budget_lines pbl
237: WHERE pbv.budget_version_id = pra.budget_version_id
238: AND pbv.award_id = P_AWARD_ID

Line 467: from gms_budget_versions

463:
464: cursor draft_budget_csr (p_award_id in NUMBER)
465: is
466: select budget_version_id, project_id
467: from gms_budget_versions
468: where award_id = p_award_id
469: and budget_status_code in ('W','S');
470:
471: cursor baselined_budget_csr (p_award_id in NUMBER)

Line 474: from gms_budget_versions

470:
471: cursor baselined_budget_csr (p_award_id in NUMBER)
472: is
473: select budget_version_id, project_id
474: from gms_budget_versions
475: where award_id = p_award_id
476: and budget_status_code = 'B'
477: and current_flag = 'Y';
478:

Line 547: FROM gms_budget_versions pbv,

543:
544:
545: CURSOR budget_lines_csr IS
546: SELECT 1
547: FROM gms_budget_versions pbv,
548: gms_resource_assignments pra,
549: gms_budget_lines pbl
550: WHERE pbv.budget_version_id = pra.budget_version_id
551: AND pbv.project_id = P_PROJECT_ID

Line 685: FROM gms_budget_versions pbv,

681: SELECT 1
682: FROM DUAL
683: WHERE EXISTS
684: ( SELECT 1
685: FROM gms_budget_versions pbv,
686: gms_resource_assignments pra,
687: gms_budget_lines pbl
688: WHERE pbv.budget_version_id = pra.budget_version_id
689: AND pbv.project_id = P_PROJECT_ID

Line 834: FROM gms_budget_versions pbv,

830: P_TASK_ID IN PA_TASKS.TASK_ID%TYPE DEFAULT NULL) IS /* Bug# 4138033 */
831:
832: CURSOR budget_lines_csr IS
833: SELECT 1
834: FROM gms_budget_versions pbv,
835: gms_resource_assignments pra,
836: gms_budget_lines pbl
837: WHERE pbv.budget_version_id = pra.budget_version_id
838: AND pbv.project_id = P_PROJECT_ID