APPS.FEM_INTG_DIM_RULE_ENG_PKG dependencies on FEM_OBJECT_DEFINITION_B

Line 66: FEM_OBJECT_DEFINITION_B OD,

62: ELSE NULL
63: END SEGMENT_NUMBER
64: FROM
65: FEM_INTG_DIM_RULES R,
66: FEM_OBJECT_DEFINITION_B OD,
67: FEM_INTG_DIM_RULE_DEFS D,
68: FND_SEGMENT_ATTRIBUTE_VALUES A
69: WHERE
70: R.CHART_OF_ACCOUNTS_ID = pv_coa_id AND

Line 607: FROM FEM_OBJECT_DEFINITION_B B,

603: pv_progress := 'Before select of object id and folder id';
604:
605: SELECT O.OBJECT_ID, O.FOLDER_ID
606: INTO pv_dim_rule_obj_id, pv_folder_id
607: FROM FEM_OBJECT_DEFINITION_B B,
608: FEM_OBJECT_CATALOG_B O
609: WHERE B.OBJECT_DEFINITION_ID = pv_dim_rule_obj_def_id
610: AND O.OBJECT_ID = B.OBJECT_ID
611: AND O.OBJECT_TYPE_CODE = 'OGL_INTG_DIM_RULE';

Line 673: FROM FEM_OBJECT_DEFINITION_B DEF,

669: pv_progress := 'Before select of GVSC ID';
670: BEGIN
671: SELECT COA.GLOBAL_VS_COMBO_ID
672: INTO pv_gvsc_id
673: FROM FEM_OBJECT_DEFINITION_B DEF,
674: FEM_INTG_COA_GVSC_MAP COA
675: WHERE DEF.OBJECT_DEFINITION_ID = p_dim_rule_obj_def_id
676: AND COA.CHART_OF_ACCOUNTS_ID = pv_coa_id;
677: EXCEPTION

Line 778: FROM fem_object_definition_b odb,

774: WHERE org.cctr_org_display_code = 'Default'
775: AND org.value_set_id = pv_fem_vs_id)
776: WHERE def.dim_rule_obj_def_id =
777: (SELECT odb.object_definition_id
778: FROM fem_object_definition_b odb,
779: fem_intg_dim_rules rule
780: WHERE odb.object_id = rule.dim_rule_obj_id
781: AND rule.chart_of_accounts_id = pv_coa_id
782: AND rule.dimension_id = 0)

Line 796: , fem_object_definition_b objdef

792: INTO v_cctr_map_option_code
793: , v_cctr_seg_count
794: from fem_intg_dim_rules rules
795: , fem_intg_dim_rule_defs ruledef
796: , fem_object_definition_b objdef
797: where rules.chart_of_accounts_id = pv_coa_id
798: and rules.dim_rule_obj_id = objdef.object_id
799: and objdef.object_definition_id = ruledef.dim_rule_obj_def_id
800: and rules.dimension_id = pv_cctr_org_dim_id;

Line 1525: FROM fem_object_definition_b odb,

1521: -- Run Intercompany if applicable
1522: IF pv_dim_varchar_label = 'COMPANY_COST_CENTER_ORG' THEN
1523: SELECT odb.object_definition_id
1524: INTO v_interco_rule_def_id
1525: FROM fem_object_definition_b odb,
1526: fem_intg_dim_rules rule
1527: WHERE odb.object_id = rule.dim_rule_obj_id
1528: AND rule.chart_of_accounts_id = pv_coa_id
1529: AND rule.dimension_id = 0;

Line 2260: FROM fem_object_definition_b

2256: -- get the object definition id for the dimension rule object id passed in
2257:
2258: SELECT object_definition_id
2259: INTO l_obj_def_id
2260: FROM fem_object_definition_b
2261: WHERE object_id = p_dim_rule_obj_id ;
2262:
2263: FEM_ENGINES_PKG.Tech_Message
2264: (p_severity => pc_log_level_statement,

Line 2344: FROM fem_object_definition_b odb,

2340: IF(l_dim_id = 8) THEN
2341:
2342: SELECT odb.object_id,odb.object_definition_id
2343: INTO l_intercomp_obj_id,l_intercomp_obj_def_id
2344: FROM fem_object_definition_b odb,
2345: fem_intg_dim_rules idr
2346: WHERE odb.object_id = idr.dim_rule_obj_id
2347: And idr.chart_of_accounts_id = l_chart_of_accounts_id
2348: AND idr.dimension_id = 0;