DBA Data[Home] [Help]

APPS.PA_TASK_ASSIGNMENTS_PVT dependencies on PA_PROJ_FP_OPTIONS

Line 66: l_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE;

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

Line 194: select TRACK_WORKPLAN_COSTS_FLAG enabled_flag from pa_proj_fp_options

190: c_rec_out c_cur_out%ROWTYPE;
191:
192:
193: CURSOR C_Workplan_Costs_enabled(p_budget_version_id IN NUMBER) IS
194: select TRACK_WORKPLAN_COSTS_FLAG enabled_flag from pa_proj_fp_options
195: where fin_plan_version_id = p_budget_version_id;
196: C_Workplan_costs_rec C_Workplan_Costs_enabled%ROWTYPE;
197:
198: -- MOAC Changes: Bug 4363092: removed nvl with org_id

Line 211: ,pa_proj_fp_options ppfo

207: FROM gl_sets_of_books gsb
208: ,pa_implementations_all pia
209: ,pa_projects_all ppa
210: ,pa_budget_versions pbv
211: ,pa_proj_fp_options ppfo
212: WHERE ppa.project_id = pbv.project_id
213: AND pbv.budget_version_id = ppfo.fin_plan_version_id
214: AND ppa.org_id = pia.org_id
215: AND gsb.set_of_books_id = pia.set_of_books_id

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

581: l_resource_assignment_id_tbl.extend(l_count);
582:
583: --dbms_output.put_line('Entering Loop for internal table set..');
584:
585: -- Bug 3866222: Get info from pa_proj_fp_options for checking period details
586: OPEN get_fp_options_csr(l_budget_version_id);
587: FETCH get_fp_options_csr INTO
588: l_period_set_name
589: ,l_accounted_period_type

Line 1318: l_time_phase_code pa_proj_fp_options.cost_time_phased_code%type;

1314:
1315: l_period_set_name gl_sets_of_books.period_set_name%type;
1316: l_accounted_period_type gl_sets_of_books.accounted_period_type%type;
1317: l_pa_period_type pa_implementations_all.pa_period_type%type;
1318: l_time_phase_code pa_proj_fp_options.cost_time_phased_code%type;
1319:
1320:
1321: cursor c_period_data IS
1322: SELECT gsb.period_set_name

Line 1334: ,pa_proj_fp_options ppfo

1330: FROM gl_sets_of_books gsb
1331: ,pa_implementations_all pia
1332: ,pa_projects_all ppa
1333: ,pa_budget_versions pbv
1334: ,pa_proj_fp_options ppfo
1335: ,gl_periods glp
1336: WHERE ppa.project_id = pbv.project_id
1337: AND pbv.budget_version_id = ppfo.fin_plan_version_id
1338: AND nvl(ppa.org_id,-99) = nvl(pia.org_id,-99)

Line 2020: p_time_phase_code IN pa_proj_fp_options.cost_time_phased_code%TYPE,

2016:
2017: PROCEDURE Check_Period_Details(
2018: P_BUDGET_VERSION_ID IN pa_budget_versions.budget_version_id%TYPE,
2019: p_period_set_name IN gl_periods.period_set_name%TYPE,
2020: p_time_phase_code IN pa_proj_fp_options.cost_time_phased_code%TYPE,
2021: p_accounted_period_type IN gl_periods.period_type%TYPE,
2022: p_pa_period_type IN gl_periods.period_type%TYPE,
2023: p_task_name IN pa_proj_elements.name%TYPE,
2024: p_rlm_alias IN pa_resource_list_members.alias%TYPE,