APPS.PA_FP_CONTROL_ITEMS_UTILS dependencies on PA_FIN_PLAN_TYPES_TL

Line 665: l_targ_pt_name pa_fin_plan_types_tl.name%TYPE;

661: l_s_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
662: l_t_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
663: l_s_fin_plan_level_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
664: l_t_fin_plan_level_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
665: l_targ_pt_name pa_fin_plan_types_tl.name%TYPE;
666: l_src_ci_number pa_control_items.ci_number%TYPE;
667: l_module_name varchar2(30) := 'check is possible';
668: BEGIN
669: IF P_PA_DEBUG_MODE = 'Y' THEN

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

2374: x_approved_rev_flag,
2375: x_fin_plan_type_id,
2376: x_plan_type_name,
2377: x_plan_class_code
2378: FROM pa_budget_versions bv, pa_fin_plan_types_tl patl,pa_fin_plan_types_b pftb
2379: WHERE bv.budget_version_id = p_budget_version_id
2380: and bv.project_id = p_project_id
2381: and bv.fin_plan_type_id = patl.fin_plan_type_id
2382: and patl.fin_plan_type_id = pftb.fin_plan_type_id

Line 2467: l_plan_name pa_fin_plan_types_tl.name%TYPE;

2463:
2464: l_msg_index_out number;
2465: l_exists varchar2(1) := 'N';
2466: l_project_name pa_projects_all.name%TYPE;
2467: l_plan_name pa_fin_plan_types_tl.name%TYPE;
2468: l_version_type pa_lookups.meaning%TYPE;
2469: l_stage number;
2470: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
2471: l_msg_name fnd_new_messages.message_name%TYPE;

Line 2504: from pa_fin_plan_types_tl

2500: l_stage := 200;
2501:
2502: select name
2503: into l_plan_name
2504: from pa_fin_plan_types_tl
2505: where fin_plan_type_id = p_fin_plan_type_id
2506: and language = userenv('LANG');
2507:
2508: l_stage := 300;