APPS.PA_FP_CONTROL_ITEMS_UTILS dependencies on PA_FIN_PLAN_TYPES_TL

Line 689: l_targ_pt_name pa_fin_plan_types_tl.name%TYPE;

685: l_s_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
686: l_t_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
687: l_s_fin_plan_level_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
688: l_t_fin_plan_level_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
689: l_targ_pt_name pa_fin_plan_types_tl.name%TYPE;
690: l_src_ci_number pa_control_items.ci_number%TYPE;
691: l_module_name varchar2(30) := 'check is possible';
692:
693: -- Bug 5845142

Line 2412: FROM pa_budget_versions bv, pa_fin_plan_types_tl patl,pa_fin_plan_types_b pftb

2408: x_approved_rev_flag,
2409: x_fin_plan_type_id,
2410: x_plan_type_name,
2411: x_plan_class_code
2412: FROM pa_budget_versions bv, pa_fin_plan_types_tl patl,pa_fin_plan_types_b pftb
2413: WHERE bv.budget_version_id = p_budget_version_id
2414: and bv.project_id = p_project_id
2415: and bv.fin_plan_type_id = patl.fin_plan_type_id
2416: and patl.fin_plan_type_id = pftb.fin_plan_type_id

Line 2501: l_plan_name pa_fin_plan_types_tl.name%TYPE;

2497:
2498: l_msg_index_out number;
2499: l_exists varchar2(1) := 'N';
2500: l_project_name pa_projects_all.name%TYPE;
2501: l_plan_name pa_fin_plan_types_tl.name%TYPE;
2502: l_version_type pa_lookups.meaning%TYPE;
2503: l_stage number;
2504: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
2505: l_msg_name fnd_new_messages.message_name%TYPE;

Line 2553: from pa_fin_plan_types_tl

2549: l_stage := 200;
2550:
2551: select name
2552: into l_plan_name
2553: from pa_fin_plan_types_tl
2554: where fin_plan_type_id = p_fin_plan_type_id
2555: and language = userenv('LANG');
2556:
2557: l_stage := 300;