APPS.PA_FP_CONTROL_ITEMS_UTILS dependencies on PA_CI_TYPES_B

Line 119: FROM pa_ci_types_b typ,pa_control_items ci

115: -- typ.SUPP_COST_REG_FLAG,
116: decode(typ.DIR_REG_REV_COL_FLAG,'N','COST_ONLY','COST_AND_REV_SAME')
117: INTO
118: x_fp_pref_code
119: FROM pa_ci_types_b typ,pa_control_items ci
120: WHERE ci.ci_type_id = typ.ci_type_id
121: and ci.Project_Id = p_project_id
122: and ci.ci_id = p_ci_id
123: and typ.impact_budget_type_code in('DIRECT_COST_ENTRY');

Line 10165: FUNCTION validate_fp_ci_type_delete (p_ci_type_id IN pa_ci_types_b.ci_type_id%TYPE)

10161: * deleting any CI type from the system, to check if the ci type is being used
10162: * in any financial plan type context to define implementation/inclusion statuses
10163: * for financial impact implementation
10164: */
10165: FUNCTION validate_fp_ci_type_delete (p_ci_type_id IN pa_ci_types_b.ci_type_id%TYPE)
10166: RETURN VARCHAR2
10167: IS
10168: l_debug_mode VARCHAR2(30);
10169: l_module_name VARCHAR2(30) := 'validate_fp_ci_type_delete';