[Home] [Help]
21: , fp.fin_plan_option_level_code
22: --Bug 4046524
23: , pa.project_currency_code
24: , pa.projfunc_currency_code
25: from pa_proj_fp_options fp, pa_projects_all pa,
26: pa_budget_versions pbv
27: where fp.project_id = pa.project_id
28: and fp.project_id = c_project_id
29: and pbv.budget_version_id=c_budget_ver_id
42: where fin_plan_version_id = c_budget_ver_id and
43: fin_plan_option_level_code like 'PLAN_VERSION';
44:
45: --Bug 4919018. SQL Repository Performance Activity
46: cursor ftch_period_details_csr(c_org_id pa_projects_all.org_id%type) is
47: select pi.pa_period_type,sob.accounted_period_type, sob.period_set_name from
48: pa_implementations_all pi,
49: gl_sets_of_books sob
50: where nvl(pi.org_id,-99) = c_org_id
77: group by resource_assignment_id
78: having count(*) > 1);
79:
80: --Bug 4176129
81: cursor get_per_type_csr(c_org_id pa_projects_all.org_id%type,
82: c_period_set_name gl_sets_of_books.period_set_name%type) is
83: select pi.pa_period_type,sob.accounted_period_type
84: from pa_implementations_all pi,
85: gl_sets_of_books sob
153: -- Bug 4299635. The amounts are rounded to atmost 5 digits. This is done to make sure that the amounts
154: -- for date range budgets are correctly upgraded to periodic budgets. PC/PFC amounts need not be rounded
155: -- since they will re-derived by MC api which is called in PAFPUPGB.pls
156: cursor get_budget_lines_csr(l_budget_version_id pa_budget_lines.budget_version_id%type,l_res_assign_id pa_resource_assignments.resource_assignment_id%type
157: ,l_org_id pa_projects_all.org_id%type,l_per_type pa_implementations_all.pa_period_type%type,l_period_set_name gl_sets_of_books.period_set_name%type) is
158: select
159: rs.resource_assignment_id resource_assignment_id,
160: rs.txn_currency_code txn_currency_code,
161: rs.gl_start_date gl_start_date,
282:
283:
284: -- Bug 3804286, 12-AUG-04, jwhite -----------------------------------------------
285:
286: l_project_start_date pa_projects_all.start_date%TYPE := NULL;
287: l_org_id pa_projects_all.org_id%TYPE := NULL;
288:
289: l_period_mask_id pa_period_masks_b.period_mask_id%type;
290: l_curr_plan_period pa_budget_versions.current_planning_period%type;
283:
284: -- Bug 3804286, 12-AUG-04, jwhite -----------------------------------------------
285:
286: l_project_start_date pa_projects_all.start_date%TYPE := NULL;
287: l_org_id pa_projects_all.org_id%TYPE := NULL;
288:
289: l_period_mask_id pa_period_masks_b.period_mask_id%type;
290: l_curr_plan_period pa_budget_versions.current_planning_period%type;
291: l_cost_current_planning_period pa_proj_fp_options.cost_current_planning_period%type;
1659: FUNCTION get_time_phase_mode
1660: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
1661: ,p_pa_period_type IN pa_implementations_all.pa_period_type%TYPE
1662: ,p_gl_period_type IN gl_sets_of_books.accounted_period_type%TYPE
1663: ,p_org_id IN pa_projects_all.org_id%TYPE) RETURN VARCHAR2
1664: IS
1665: --Bug 4174789. In the expression to derive factor, replaced the division with substraction to nullify
1666: --errors because of infinite digits after decimal point
1667: CURSOR c_derive_time_phase_csr(c_period_type gl_periods.period_type%TYPE)