APPS.FEM_INTG_DIM_RULE_ENG_PKG dependencies on FEM_INTG_DIM_RULES

Line 65: FEM_INTG_DIM_RULES R,

61: A.APPLICATION_COLUMN_NAME THEN 5
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

Line 104: FROM FEM_INTG_DIM_RULES R

100: INTO pv_dim_id
101: ,pv_dim_varchar_label
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

Line 779: fem_intg_dim_rules rule

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)
783: AND def.dim_mapping_option_code = 'SINGLEVAL';

Line 794: from fem_intg_dim_rules rules

790: SELECT ruledef.DIM_MAPPING_OPTION_CODE
791: , ruledef.SEGMENT_COUNT
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

Line 1526: fem_intg_dim_rules rule

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;
1530:

Line 2246: FROM fem_intg_dim_rules

2242: SELECT chart_of_accounts_id,
2243: dimension_id
2244: INTO l_chart_of_accounts_id,
2245: l_dim_id
2246: FROM fem_intg_dim_rules
2247: WHERE dim_rule_obj_id = p_dim_rule_obj_id;
2248:
2249: -- retrieving the global value set combination id for chart of accounts
2250:

Line 2345: fem_intg_dim_rules idr

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;
2349: