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_FUNDS_CONTROL_PKG dependencies on GMS_BUDGETARY_CONTROLS

Line 4281: FROM gms_budgetary_controls gbc

4277: g_error_stage := 'FUND_CTRL_LEVEL_CODE : A';
4278: -- Award Level
4279: UPDATE gms_bc_packets gms
4280: SET a_funds_control_level_code = (SELECT funds_control_level_code
4281: FROM gms_budgetary_controls gbc
4282: WHERE gbc.project_id = gms.project_id
4283: AND gbc.award_id = gms.award_id
4284: AND gbc.task_id IS NULL
4285: AND gbc.parent_member_id IS NULL

Line 4297: FROM gms_budgetary_controls gbc

4293: g_error_stage := 'FUND_CTRL_LEVEL_CODE : TT';
4294: -- Top Task Level
4295: UPDATE gms_bc_packets gms
4296: SET tt_funds_control_level_code = (SELECT funds_control_level_code
4297: FROM gms_budgetary_controls gbc
4298: WHERE gbc.project_id = gms.project_id
4299: AND gbc.award_id = gms.award_id
4300: AND gbc.task_id = gms.top_task_id
4301: AND gbc.parent_member_id IS NULL

Line 4319: FROM gms_budgetary_controls gbc

4315:
4316: -- Task Level
4317: UPDATE gms_bc_packets gms
4318: SET t_funds_control_level_code = (SELECT funds_control_level_code
4319: FROM gms_budgetary_controls gbc
4320: WHERE gbc.project_id = gms.project_id
4321: AND gbc.award_id = gms.award_id
4322: AND gbc.task_id = gms.task_id -- bug 2579619 : gms.bud_task_id
4323: AND gbc.parent_member_id IS NULL

Line 4342: FROM gms_budgetary_controls gbc

4338: -- Resource Group Level
4339: g_error_stage := 'FUND_CTRL_LEVEL_CODE : RG';
4340: UPDATE gms_bc_packets gms
4341: SET rg_funds_control_level_code = (SELECT funds_control_level_code
4342: FROM gms_budgetary_controls gbc
4343: WHERE gbc.project_id = gms.project_id
4344: AND gbc.award_id = gms.award_id
4345: AND gbc.task_id = gms.bud_task_id
4346: AND gbc.resource_list_member_id =

Line 4365: FROM gms_budgetary_controls gbc

4361: -- Resource Level
4362: g_error_stage := 'FUND_CTRL_LEVEL_CODE : R';
4363: UPDATE gms_bc_packets gms
4364: SET r_funds_control_level_code = (SELECT funds_control_level_code
4365: FROM gms_budgetary_controls gbc
4366: WHERE gbc.project_id = gms.project_id
4367: AND gbc.award_id = gms.award_id
4368: AND gbc.task_id = gms.bud_task_id
4369: AND gbc.resource_list_member_id =