APPS.GMS_FUNDS_CONTROL_PKG dependencies on GMS_BUDGET_VERSIONS

Line 119: from gms_budget_versions

115: -------------------------------------------------------------------------------------------------- */
116: Procedure Lock_budget_versions(p_packet_id number) is
117: Cursor c_lock_bvid is
118: select budget_version_id
119: from gms_budget_versions
120: where budget_version_id in
121: (select budget_version_id from gms_bc_packets_bvid)
122: for update;
123: Begin

Line 125: null; -- Dummy code to lock gms_budget_versions

121: (select budget_version_id from gms_bc_packets_bvid)
122: for update;
123: Begin
124: for x in c_lock_bvid loop
125: null; -- Dummy code to lock gms_budget_versions
126: end loop;
127: End Lock_budget_versions;
128:
129: /* -----------------------------------------------------------------------------------------------

Line 3532: FROM gms_budget_versions pb, pa_budget_entry_methods pbm, gms_awards ga

3528: x_boundary_code,
3529: x_time_phased_type_code,
3530: x_categorization_code,
3531: x_resource_list_id
3532: FROM gms_budget_versions pb, pa_budget_entry_methods pbm, gms_awards ga
3533: WHERE ga.award_id = pb.award_id
3534: AND pb.project_id = x_project_id
3535: AND pb.award_id = x_award_id
3536: AND pb.budget_entry_method_code = pbm.budget_entry_method_code

Line 3826: FROM pa_budget_entry_methods bem, gms_budget_versions bv,

3822: UPDATE gms_bc_packets bc
3823: SET (bc.bud_task_id, bc.top_task_id) =
3824: (SELECT DECODE (bem.entry_level_code, 'P', 0, 'L', bc.task_id, t.top_task_id),
3825: DECODE (bem.entry_level_code, 'P', 0, t.top_task_id)
3826: FROM pa_budget_entry_methods bem, gms_budget_versions bv,
3827: pa_tasks t
3828: WHERE bv.budget_version_id = bc.budget_version_id
3829: AND bv.budget_entry_method_code = bem.budget_entry_method_code
3830: AND bem.entry_level_code IN ('P', 'L', 'T')

Line 3837: FROM pa_budget_entry_methods bem1, gms_budget_versions bv1

3833: AND bc.status_code = 'P'
3834: AND bc.bud_task_id IS NULL
3835: AND nvl(bc.burden_adjustment_flag,'N') = 'N' -- 3389292
3836: AND EXISTS ( SELECT 1
3837: FROM pa_budget_entry_methods bem1, gms_budget_versions bv1
3838: WHERE bv1.budget_version_id = bc.budget_version_id
3839: AND bv1.budget_entry_method_code = bem1.budget_entry_method_code
3840: AND bem1.entry_level_code IN ('P', 'L', 'T'));
3841:

Line 3855: FROM pa_budget_entry_methods bem, gms_budget_versions bv,

3851: UPDATE gms_bc_packets bc
3852: SET (bc.bud_task_id, bc.top_task_id) =
3853: (SELECT t.task_id,
3854: t.top_task_id
3855: FROM pa_budget_entry_methods bem, gms_budget_versions bv,
3856: pa_tasks t
3857: WHERE bv.budget_version_id = bc.budget_version_id
3858: AND bv.budget_entry_method_code = bem.budget_entry_method_code
3859: AND bem.entry_level_code = 'M'

Line 3880: FROM pa_budget_entry_methods bem, gms_budget_versions bv,pa_tasks t

3876: UPDATE gms_bc_packets bc
3877: SET (bc.bud_task_id, bc.top_task_id) =
3878: (SELECT t.task_id,
3879: t.top_task_id
3880: FROM pa_budget_entry_methods bem, gms_budget_versions bv,pa_tasks t
3881: WHERE bv.budget_version_id = bc.budget_version_id
3882: AND bv.budget_entry_method_code = bem.budget_entry_method_code
3883: AND bem.entry_level_code = 'M'
3884: AND t.task_id = (SELECT task_id