[Home] [Help]
48: select end_date from gms_balances
49: where budget_version_id = x_budget_version_id
50: for update nowait;
51: ---------------------------------------------------------------------------------------------
52: -- procedure to re-create the gms_balance records from GMS_BUDGET_LINES
53: -- and to clean up GMS_BC_PACKETs
54: -- Added x_project_id and x_award_id parameter : ported Bug 1703510
55:
56: procedure create_gms_balance( x_budget_version_id in number, x_set_of_books_id in number,
65: where project_id = x_project_id
66: and award_id = x_award_id
67: and budget_version_id = x_budget_version_id;
68:
69: -- insert into gms_balances table from gms_budget_lines
70: insert into gms_balances (
71: PROJECT_ID,
72: AWARD_ID,
73: TASK_ID,
105: gb.END_DATE,
106: rm.PARENT_MEMBER_ID,
107: gb.burdened_cost --gb.raw_cost
108: from
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
1842: gbl.END_DATE,
1843: rm.PARENT_MEMBER_ID,
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