APPS.FEM_INTG_DIM_RULE_ENG_PKG dependencies on FEM_DIMENSIONS_B

Line 106: ,FEM_DIMENSIONS_B B

102: ,pv_coa_id
103: ,pv_coa_name
104: FROM FEM_INTG_DIM_RULES R
105: ,FND_ID_FLEX_STRUCTURES F
106: ,FEM_DIMENSIONS_B B
107: WHERE R.DIM_RULE_OBJ_ID = pv_dim_rule_obj_id
108: AND F.APPLICATION_ID = 101
109: AND F.ID_FLEX_CODE = 'GL#'
110: AND F.ID_FLEX_NUM = R.CHART_OF_ACCOUNTS_ID

Line 243: FROM FEM_DIMENSIONS_B

239: -- ----------------------------------------------------------
240: BEGIN
241: SELECT DIMENSION_ID
242: INTO pv_cctr_org_dim_id
243: FROM FEM_DIMENSIONS_B
244: WHERE DIMENSION_VARCHAR_LABEL = 'COMPANY_COST_CENTER_ORG';
245: EXCEPTION
246: WHEN NO_DATA_FOUND THEN
247: pv_cctr_org_dim_id := -1;

Line 259: FROM FEM_DIMENSIONS_B

255:
256: BEGIN
257: SELECT DIMENSION_ID
258: INTO pv_fin_element_dim_id
259: FROM FEM_DIMENSIONS_B
260: WHERE DIMENSION_VARCHAR_LABEL = 'FINANCIAL_ELEMENT';
261: EXCEPTION
262: WHEN NO_DATA_FOUND THEN
263: pv_fin_element_dim_id := -1;

Line 310: FROM FEM_DIMENSIONS_B

306: BEGIN
307: pv_progress := 'Get pv_com_dim_id';
308: SELECT DIMENSION_ID
309: INTO pv_com_dim_id
310: FROM FEM_DIMENSIONS_B
311: WHERE DIMENSION_VARCHAR_LABEL = 'COMPANY';
312:
313: pv_progress := 'Get pv_cc_dim_id';
314: SELECT DIMENSION_ID

Line 316: FROM FEM_DIMENSIONS_B

312:
313: pv_progress := 'Get pv_cc_dim_id';
314: SELECT DIMENSION_ID
315: INTO pv_cc_dim_id
316: FROM FEM_DIMENSIONS_B
317: WHERE DIMENSION_VARCHAR_LABEL = 'COST_CENTER';
318: EXCEPTION
319: WHEN NO_DATA_FOUND THEN
320: IF pv_dim_mapping_option_code = 'MULTISEG'