APPS.FEM_INTG_NEW_DIM_MEMBER_PKG dependencies on FEM_INTG_DIM_RULES

Line 2091: fem_intg_dim_rules idr,

2087: FROM dual
2088: WHERE EXISTS ( SELECT 1
2089: FROM fnd_concurrent_programs fcp,
2090: fnd_concurrent_requests fcr,
2091: fem_intg_dim_rules idr,
2092: fem_object_definition_b fodb
2093: WHERE fcp.concurrent_program_id = fcr.concurrent_program_id
2094: AND fcp.application_id = fcr.program_application_id
2095: AND fcp.application_id = 274

Line 2168: FROM fem_intg_dim_rules idr,

2164:
2165: UPDATE FEM_INTG_DIM_RULE_DEFS
2166: SET MAX_CCID_PROCESSED = FEM_INTG_DIM_RULE_ENG_PKG.pv_max_ccid_to_be_mapped
2167: WHERE DIM_RULE_OBJ_DEF_ID IN ( SELECT defs.dim_rule_obj_def_id
2168: FROM fem_intg_dim_rules idr,
2169: fem_object_definition_b fodb,
2170: fem_xdim_dimensions fxd,
2171: fem_intg_dim_rule_defs defs,
2172: fem_tab_columns_b ftcb

Line 4014: fem_intg_dim_rules idr,

4010: FROM dual
4011: WHERE EXISTS ( SELECT 1
4012: FROM fnd_concurrent_programs fcp,
4013: fnd_concurrent_requests fcr,
4014: fem_intg_dim_rules idr,
4015: fem_object_definition_b fodb
4016: WHERE fcp.concurrent_program_id = fcr.concurrent_program_id
4017: AND fcp.application_id = fcr.program_application_id
4018: AND fcp.application_id = 274

Line 4091: FROM fem_intg_dim_rules idr,

4087:
4088: UPDATE FEM_INTG_DIM_RULE_DEFS
4089: SET MAX_CCID_PROCESSED = FEM_INTG_DIM_RULE_ENG_PKG.pv_max_ccid_to_be_mapped
4090: WHERE DIM_RULE_OBJ_DEF_ID IN ( SELECT defs.dim_rule_obj_def_id
4091: FROM fem_intg_dim_rules idr,
4092: fem_object_definition_b fodb,
4093: fem_xdim_dimensions fxd,
4094: fem_intg_dim_rule_defs defs,
4095: fem_tab_columns_b ftcb

Line 4626: FROM fem_intg_dim_rules idr,

4622: NVL(defs.fem_value_set_id,-1) fem_value_set_id,
4623: defs.application_column_name1,
4624: defs.default_member_id,
4625: defs.dim_mapping_option_code
4626: FROM fem_intg_dim_rules idr,
4627: fem_object_definition_b fodb,
4628: fem_xdim_dimensions fxd,
4629: fem_intg_dim_rule_defs defs,
4630: fem_tab_columns_b ftcb