DBA Data[Home] [Help]

APPS.GMS_FUNDS_CONTROL_PKG dependencies on PA_BUDGET_ENTRY_METHODS

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

Line 4096: x_time_phased_type_code IN pa_budget_entry_methods.time_phased_type_code%TYPE,

4092: x_bc_packet_id IN NUMBER,
4093: x_project_id IN gms_bc_packets.project_id%TYPE,
4094: x_award_id IN gms_bc_packets.award_id%TYPE,
4095: x_budget_version_id IN gms_bc_packets.budget_version_id%TYPE,
4096: x_time_phased_type_code IN pa_budget_entry_methods.time_phased_type_code%TYPE,
4097: x_expenditure_item_date IN DATE,
4098: x_amount_type IN gms_awards.amount_type%TYPE,
4099: x_boundary_code IN gms_awards.boundary_code%TYPE,
4100: x_set_of_books_id IN gms_bc_packets.set_of_books_id%TYPE,