APPS.GMS_FUNDS_CONTROL_PKG dependencies on PA_BUDGET_ENTRY_METHODS

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

3834: x_boundary_code,
3835: x_time_phased_type_code,
3836: x_categorization_code,
3837: x_resource_list_id
3838: FROM gms_budget_versions pb, pa_budget_entry_methods pbm, gms_awards ga
3839: WHERE ga.award_id = pb.award_id
3840: AND pb.project_id = x_project_id
3841: AND pb.award_id = x_award_id
3842: AND pb.budget_entry_method_code = pbm.budget_entry_method_code

Line 4132: FROM pa_budget_entry_methods bem, gms_budget_versions bv,

4128: UPDATE gms_bc_packets bc
4129: SET (bc.bud_task_id, bc.top_task_id) =
4130: (SELECT DECODE (bem.entry_level_code, 'P', 0, 'L', bc.task_id, t.top_task_id),
4131: DECODE (bem.entry_level_code, 'P', 0, t.top_task_id)
4132: FROM pa_budget_entry_methods bem, gms_budget_versions bv,
4133: pa_tasks t
4134: WHERE bv.budget_version_id = bc.budget_version_id
4135: AND bv.budget_entry_method_code = bem.budget_entry_method_code
4136: AND bem.entry_level_code IN ('P', 'L', 'T')

Line 4143: FROM pa_budget_entry_methods bem1, gms_budget_versions bv1

4139: AND bc.status_code = 'P'
4140: AND bc.bud_task_id IS NULL
4141: AND nvl(bc.burden_adjustment_flag,'N') = 'N' -- 3389292
4142: AND EXISTS ( SELECT 1
4143: FROM pa_budget_entry_methods bem1, gms_budget_versions bv1
4144: WHERE bv1.budget_version_id = bc.budget_version_id
4145: AND bv1.budget_entry_method_code = bem1.budget_entry_method_code
4146: AND bem1.entry_level_code IN ('P', 'L', 'T'));
4147:

Line 4161: FROM pa_budget_entry_methods bem, gms_budget_versions bv,

4157: UPDATE gms_bc_packets bc
4158: SET (bc.bud_task_id, bc.top_task_id) =
4159: (SELECT t.task_id,
4160: t.top_task_id
4161: FROM pa_budget_entry_methods bem, gms_budget_versions bv,
4162: pa_tasks t
4163: WHERE bv.budget_version_id = bc.budget_version_id
4164: AND bv.budget_entry_method_code = bem.budget_entry_method_code
4165: AND bem.entry_level_code = 'M'

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

4182: UPDATE gms_bc_packets bc
4183: SET (bc.bud_task_id, bc.top_task_id) =
4184: (SELECT t.task_id,
4185: t.top_task_id
4186: FROM pa_budget_entry_methods bem, gms_budget_versions bv,pa_tasks t
4187: WHERE bv.budget_version_id = bc.budget_version_id
4188: AND bv.budget_entry_method_code = bem.budget_entry_method_code
4189: AND bem.entry_level_code = 'M'
4190: AND t.task_id = (SELECT task_id

Line 4450: x_time_phased_type_code IN pa_budget_entry_methods.time_phased_type_code%TYPE,

4446: x_bc_packet_id IN NUMBER,
4447: x_project_id IN gms_bc_packets.project_id%TYPE,
4448: x_award_id IN gms_bc_packets.award_id%TYPE,
4449: x_budget_version_id IN gms_bc_packets.budget_version_id%TYPE,
4450: x_time_phased_type_code IN pa_budget_entry_methods.time_phased_type_code%TYPE,
4451: x_expenditure_item_date IN DATE,
4452: x_amount_type IN gms_awards.amount_type%TYPE,
4453: x_boundary_code IN gms_awards.boundary_code%TYPE,
4454: x_set_of_books_id IN gms_bc_packets.set_of_books_id%TYPE,