APPS.FEM_DEFCALP_UTIL_PKG dependencies on FEM_CAL_PERIODS_B

Line 144: from fem_cal_periods_b;

140: BEGIN -- Create default Cal Period and Ledger
141:
142: select count(*)
143: into v_cal_period_count
144: from fem_cal_periods_b;
145:
146: -- If one cal_period exists in the db, then we don't
147: -- want to create a default cal_period, nor do we want
148: -- to create a cal_period hier or default ledger

Line 929: FROM fem_cal_periods_b

925: (SELECT hierarchy_obj_id
926: FROM fem_hierarchies
927: WHERE calendar_id IN
928: (SELECT calendar_id
929: FROM fem_cal_periods_b
930: WHERE enabled_flag = 'Y')))
931: AND attribute_id = v_cal_hier_attribute_id
932: AND version_id = v_cal_hier_version_id);
933: END IF;

Line 946: FROM fem_cal_periods_b

942: -- BUDGET_LEDGER.
943: IF v_cal_period_id IS NULL THEN
944: SELECT min(cal_period_id) KEEP (DENSE_RANK FIRST ORDER BY creation_date)
945: INTO v_cal_period_id
946: FROM fem_cal_periods_b
947: WHERE enabled_flag = 'Y'
948: AND calendar_id IN
949: (SELECT calendar_id
950: FROM fem_hierarchies