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.

[Home] [Help]

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 225: FROM gms_budget_versions pbv,

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

Line 449: from gms_budget_versions

445:
446: cursor draft_budget_csr (p_award_id in NUMBER)
447: is
448: select budget_version_id, project_id
449: from gms_budget_versions
450: where award_id = p_award_id
451: and budget_status_code in ('W','S');
452:
453: cursor baselined_budget_csr (p_award_id in NUMBER)

Line 456: from gms_budget_versions

452:
453: cursor baselined_budget_csr (p_award_id in NUMBER)
454: is
455: select budget_version_id, project_id
456: from gms_budget_versions
457: where award_id = p_award_id
458: and budget_status_code = 'B'
459: and current_flag = 'Y';
460:

Line 529: FROM gms_budget_versions pbv,

525:
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

Line 639: FROM gms_budget_versions pbv,

635: SELECT 1
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

Line 788: FROM gms_budget_versions pbv,

784: P_TASK_ID IN PA_TASKS.TASK_ID%TYPE DEFAULT NULL) IS /* Bug# 4138033 */
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