DBA Data[Home] [Help]

APPS.PA_FP_CONTROL_ITEMS_UTILS dependencies on PA_FIN_PLAN_TYPES_VL

Line 724: FROM pa_fin_plan_types_vl fin,

720: IF p_calling_mode='IMPLEMENT' THEN
721:
722: SELECT name
723: INTO l_targ_pt_name
724: FROM pa_fin_plan_types_vl fin,
725: pa_budget_versions pbv
726: WHERE fin.fin_plan_type_id = pbv.fin_plan_type_id
727: AND pbv.budget_version_id= l_t_version_id;
728:

Line 7842: FROM pa_fin_plan_types_vl fin,

7838: ,pfo.fin_plan_type_id
7839: ,pfo.approved_cost_plan_type_flag
7840: ,pfo.approved_rev_plan_type_flag
7841: ,fin.plan_class_code
7842: FROM pa_fin_plan_types_vl fin,
7843: pa_proj_fp_options pfo
7844: WHERE pfo.project_id = p_project_id
7845: AND pfo.fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE
7846: AND pfo.fin_plan_type_id = fin.fin_plan_type_id