APPS.FEM_DEFCALP_UTIL_PKG dependencies on FEM_DIMENSIONS_B

Line 118: v_dim_id FEM_DIMENSIONS_B.dimension_id%TYPE;

114: v_bus_rel_attr_id NUMBER;
115: v_customer_dim_id NUMBER;
116:
117: -- Other variables
118: v_dim_id FEM_DIMENSIONS_B.dimension_id%TYPE;
119: v_count NUMBER;
120:
121: -- Message Variables
122: v_msg_count NUMBER;

Line 885: FROM fem_dimensions_b

881:
882: -- Get BUDGET dimension id
883: SELECT dimension_id
884: INTO v_dim_id
885: FROM fem_dimensions_b
886: WHERE dimension_varchar_label = 'BUDGET';
887:
888: SELECT count(*)
889: INTO v_count

Line 910: FROM fem_dimensions_b

906: AND v.attribute_id = a.attribute_id
907: AND v.default_version_flag = 'Y'
908: AND a.dimension_id =
909: (SELECT dimension_id
910: FROM fem_dimensions_b
911: WHERE dimension_varchar_label = 'LEDGER');
912:
913: -- Then find the ledger
914: SELECT min(ledger_id)

Line 980: FROM fem_dimensions_b

976: AND A.attribute_id = V.attribute_id
977: AND V.default_version_flag = 'Y'
978: AND A.dimension_id IN
979: (SELECT dimension_id
980: FROM fem_dimensions_b
981: WHERE dimension_varchar_label = 'CAL_PERIOD');
982: END IF;
983:
984: UPDATE fem_dim_attributes_b

Line 1030: FROM fem_hierarchies h, fem_dimensions_b d

1026: -- Get the first Cal Period hierarchy created, which
1027: -- presumably would be the default one we seeded.
1028: SELECT MIN(h.hierarchy_obj_id)
1029: INTO v_object_id
1030: FROM fem_hierarchies h, fem_dimensions_b d
1031: WHERE d.dimension_varchar_label = 'CAL_PERIOD'
1032: AND h.dimension_id = d.dimension_id;
1033:
1034: SELECT MIN(object_definition_id)

Line 1152: FROM fem_dimensions_b

1148: WHERE bus_rel_display_code = 'INDIVIDUAL_CUSTOMER';
1149:
1150: SELECT dimension_id
1151: INTO v_customer_dim_id
1152: FROM fem_dimensions_b
1153: WHERE dimension_varchar_label = 'CUSTOMER';
1154:
1155: SELECT attribute_id
1156: INTO v_bus_rel_attr_id