APPS.PA_TASK_ASSIGNMENTS_PVT dependencies on PA_PROJ_FP_OPTIONS

Line 67: l_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE;

63:
64: l_period_set_name gl_sets_of_books.period_set_name%TYPE;
65: l_accounted_period_type gl_sets_of_books.accounted_period_type%TYPE;
66: l_pa_period_type pa_implementations_all.pa_period_type%TYPE;
67: l_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE;
68: l_period_name gl_periods.period_name%TYPE;
69: l_period_start_date DATE;
70: l_period_end_date DATE;
71: -- 10/22/04: To handle only lines after the progress as of date

Line 229: select TRACK_WORKPLAN_COSTS_FLAG enabled_flag from pa_proj_fp_options

225: c_rec_out_for_cbs c_cur_out_for_cbs%ROWTYPE;
226:
227:
228: CURSOR C_Workplan_Costs_enabled(p_budget_version_id IN NUMBER) IS
229: select TRACK_WORKPLAN_COSTS_FLAG enabled_flag from pa_proj_fp_options
230: where fin_plan_version_id = p_budget_version_id;
231: C_Workplan_costs_rec C_Workplan_Costs_enabled%ROWTYPE;
232:
233: -- MOAC Changes: Bug 4363092: removed nvl with org_id

Line 247: ,pa_proj_fp_options ppfo

243: FROM gl_sets_of_books gsb
244: ,pa_implementations_all pia
245: ,pa_projects_all ppa
246: ,pa_budget_versions pbv
247: ,pa_proj_fp_options ppfo
248: WHERE ppa.project_id = pbv.project_id
249: AND pbv.budget_version_id = ppfo.fin_plan_version_id
250: AND ppa.org_id = pia.org_id
251: AND gsb.set_of_books_id = pia.set_of_books_id

Line 627: -- Bug 3866222: Get info from pa_proj_fp_options for checking period details

623: l_resource_assignment_id_tbl.extend(l_count);
624:
625: --dbms_output.put_line('Entering Loop for internal table set..');
626:
627: -- Bug 3866222: Get info from pa_proj_fp_options for checking period details
628: OPEN get_fp_options_csr(l_budget_version_id);
629: FETCH get_fp_options_csr INTO
630: l_period_set_name
631: ,l_accounted_period_type

Line 1531: l_time_phase_code pa_proj_fp_options.cost_time_phased_code%type;

1527:
1528: l_period_set_name gl_sets_of_books.period_set_name%type;
1529: l_accounted_period_type gl_sets_of_books.accounted_period_type%type;
1530: l_pa_period_type pa_implementations_all.pa_period_type%type;
1531: l_time_phase_code pa_proj_fp_options.cost_time_phased_code%type;
1532:
1533:
1534: cursor c_period_data IS
1535: SELECT gsb.period_set_name

Line 1547: ,pa_proj_fp_options ppfo

1543: FROM gl_sets_of_books gsb
1544: ,pa_implementations_all pia
1545: ,pa_projects_all ppa
1546: ,pa_budget_versions pbv
1547: ,pa_proj_fp_options ppfo
1548: ,gl_periods glp
1549: WHERE ppa.project_id = pbv.project_id
1550: AND pbv.budget_version_id = ppfo.fin_plan_version_id
1551: AND nvl(ppa.org_id,-99) = nvl(pia.org_id,-99)

Line 2260: p_time_phase_code IN pa_proj_fp_options.cost_time_phased_code%TYPE,

2256:
2257: PROCEDURE Check_Period_Details(
2258: P_BUDGET_VERSION_ID IN pa_budget_versions.budget_version_id%TYPE,
2259: p_period_set_name IN gl_periods.period_set_name%TYPE,
2260: p_time_phase_code IN pa_proj_fp_options.cost_time_phased_code%TYPE,
2261: p_accounted_period_type IN gl_periods.period_type%TYPE,
2262: p_pa_period_type IN gl_periods.period_type%TYPE,
2263: p_task_name IN pa_proj_elements.name%TYPE,
2264: p_rlm_alias IN pa_resource_list_members.alias%TYPE,