APPS.GMS_FUNDS_CONTROL_PKG dependencies on GMS_BUDGETARY_CONTROLS

Line 3962: FROM gms_budgetary_controls gbc

3958: g_error_stage := 'FUND_CTRL_LEVEL_CODE : A';
3959: -- Award Level
3960: UPDATE gms_bc_packets gms
3961: SET a_funds_control_level_code = (SELECT funds_control_level_code
3962: FROM gms_budgetary_controls gbc
3963: WHERE gbc.project_id = gms.project_id
3964: AND gbc.award_id = gms.award_id
3965: AND gbc.task_id IS NULL
3966: AND gbc.parent_member_id IS NULL

Line 3978: FROM gms_budgetary_controls gbc

3974: g_error_stage := 'FUND_CTRL_LEVEL_CODE : TT';
3975: -- Top Task Level
3976: UPDATE gms_bc_packets gms
3977: SET tt_funds_control_level_code = (SELECT funds_control_level_code
3978: FROM gms_budgetary_controls gbc
3979: WHERE gbc.project_id = gms.project_id
3980: AND gbc.award_id = gms.award_id
3981: AND gbc.task_id = gms.top_task_id
3982: AND gbc.parent_member_id IS NULL

Line 4000: FROM gms_budgetary_controls gbc

3996:
3997: -- Task Level
3998: UPDATE gms_bc_packets gms
3999: SET t_funds_control_level_code = (SELECT funds_control_level_code
4000: FROM gms_budgetary_controls gbc
4001: WHERE gbc.project_id = gms.project_id
4002: AND gbc.award_id = gms.award_id
4003: AND gbc.task_id = gms.task_id -- bug 2579619 : gms.bud_task_id
4004: AND gbc.parent_member_id IS NULL

Line 4023: FROM gms_budgetary_controls gbc

4019: -- Resource Group Level
4020: g_error_stage := 'FUND_CTRL_LEVEL_CODE : RG';
4021: UPDATE gms_bc_packets gms
4022: SET rg_funds_control_level_code = (SELECT funds_control_level_code
4023: FROM gms_budgetary_controls gbc
4024: WHERE gbc.project_id = gms.project_id
4025: AND gbc.award_id = gms.award_id
4026: AND gbc.task_id = gms.bud_task_id
4027: AND gbc.resource_list_member_id =

Line 4046: FROM gms_budgetary_controls gbc

4042: -- Resource Level
4043: g_error_stage := 'FUND_CTRL_LEVEL_CODE : R';
4044: UPDATE gms_bc_packets gms
4045: SET r_funds_control_level_code = (SELECT funds_control_level_code
4046: FROM gms_budgetary_controls gbc
4047: WHERE gbc.project_id = gms.project_id
4048: AND gbc.award_id = gms.award_id
4049: AND gbc.task_id = gms.bud_task_id
4050: AND gbc.resource_list_member_id =