APPS.FEM_INTG_CAL_RULE_ENG_PKG dependencies on FEM_OBJECT_CATALOG_B

Line 158: FEM_OBJECT_CATALOG_B C

154: pv_cal_rule_obj_id,
155: pv_cal_rule_obj_def_id
156: FROM
157: FEM_OBJECT_DEFINITION_B D,
158: FEM_OBJECT_CATALOG_B C
159: WHERE
160: D.OBJECT_DEFINITION_ID = p_cal_rule_obj_def_id AND
161: C.OBJECT_ID = D.OBJECT_ID AND
162: C.OBJECT_TYPE_CODE='OGL_INTG_CAL_RULE';

Line 361: FEM_OBJECT_CATALOG_B C

357: pv_effective_period_num_max
358: FROM
359: FEM_INTG_CALENDAR_MAP M,
360: FEM_OBJECT_DEFINITION_B D,
361: FEM_OBJECT_CATALOG_B C
362: WHERE
363: M.PERIOD_SET_NAME = p_period_set_name AND
364: M.PERIOD_TYPE = p_period_type AND
365: D.OBJECT_DEFINITION_ID = M.CAL_PER_HIER_OBJ_DEF_ID AND

Line 574: fem_object_catalog_b o

570: INTO
571: v_cal_per_hier_obj_id
572: FROM
573: FEM_HIERARCHIES h,
574: fem_object_catalog_b o
575: WHERE
576: h.CALENDAR_ID = NVL(v_calendar_id, -1)
577: and h.PERIOD_TYPE = pv_period_type
578: and h.personal_flag = 'N'