APPS.GMS_BUDGET_BALANCE dependencies on GMS_BUDGET_VERSIONS

Line 113: gms_budget_versions gv

109: gms_budget_lines gb,
110: gms_resource_assignments ga,
111: pa_tasks pt,
112: pa_resource_list_members rm,
113: gms_budget_versions gv
114: where gv.budget_version_id = x_budget_version_id
115: and ga.resource_assignment_id = gb.resource_assignment_id
116: and ga.task_id = pt.task_id (+)
117: and ga.budget_version_id = gv.budget_version_id

Line 1352: gms_budget_versions bv,

1348: gms.parent_bc_packet_id,
1349: pm.categorization_code, -- to calculate the correct rlmi if budget without resource
1350: decode(sign(nvl(gms.entered_dr,0) - nvl(gms.entered_cr,0)),1,'D','I')
1351: from gms_bc_packets gms,
1352: gms_budget_versions bv,
1353: pa_budget_entry_methods pm,
1354: pa_expenditure_types TYPE,
1355: gms_encumbrance_items_all ei
1356: where gms.packet_id = x_packet_id

Line 1378: gms_budget_versions bv,

1374: gms.parent_bc_packet_id,
1375: pm.categorization_code, -- to calculate the correct rlmi if budget without resource
1376: decode(sign(nvl(gms.entered_dr,0) - nvl(gms.entered_cr,0)),1,'D','I')
1377: from gms_bc_packets gms,
1378: gms_budget_versions bv,
1379: pa_budget_entry_methods pm,
1380: pa_expenditure_types TYPE,
1381: pa_expenditure_items_all ei
1382: where gms.packet_id = x_packet_id

Line 1423: from gms_budget_versions bv

1419: if x_categorization_code = 'R' then -- if not categorized by resources then no call to map trans to generate rlmi
1420:
1421: Begin
1422: select bv.resource_list_id into x_res_list_id
1423: from gms_budget_versions bv
1424: where bv.budget_version_id = x_budget_version_id;
1425: Exception
1426: when others then
1427: raise;

Line 1848: gms_budget_versions gbv,

1844: gbl.burdened_cost --pb.raw_cost
1845: FROM
1846: gms_budget_lines gbl,
1847: pa_resource_assignments ra,
1848: gms_budget_versions gbv,
1849: pa_resource_list_members rm
1850: WHERE
1851: gbv.budget_version_id = p_budget_version_id
1852: and ra.resource_assignment_id = gbl.resource_assignment_id

Line 1951: from gms_budget_versions

1947: gms_error_pkg.gms_debug('gms_budget_balance -1','C');
1948: END IF;
1949: -- TO SELECT DRAFT_BUDGET_VERSION_ID FROM PA_BUDGET_VERSION TABLE.
1950: select max(budget_version_id) into x_budget_version_id
1951: from gms_budget_versions
1952: where project_id = x_project_id
1953: and award_id = to_char(x_award_id)
1954: and ((budget_status_code ='W' and x_mode='S')
1955: or (budget_status_code = 'B' and x_mode = 'B'));

Line 1969: from gms_budget_versions

1965: x_e_stage := '210';
1966:
1967: select fc_required_flag
1968: into x_fc_required_flag
1969: from gms_budget_versions
1970: where project_id = x_project_id
1971: and award_id = x_award_id
1972: and budget_status_code in ('W','S');
1973:

Line 1980: FROM gms_budget_versions

1976: BEGIN
1977:
1978: SELECT budget_version_id
1979: INTO x_base_bud_version_id
1980: FROM gms_budget_versions
1981: WHERE project_id = x_project_id
1982: AND award_id = x_award_id
1983: AND budget_status_code = 'B'
1984: AND (current_flag = 'Y'