DBA Data[Home] [Help]

APPS.GCS_FEM_HIER_SYNC_PKG dependencies on FEM_ENTITIES_B

Line 82: fem_entities_b feb

78: l_start_date,
79: l_top_entity_display_code
80: FROM gcs_hierarchies_vl ghv,
81: gcs_hierarchies_b ghb,
82: fem_entities_b feb
83: WHERE ghb.hierarchy_id = p_hierarchy_id
84: AND ghb.top_entity_id = feb.entity_id
85: AND ghv.hierarchy_id = p_hierarchy_id;
86:

Line 166: FROM fem_entities_b fev_p,

162: 1,
163: NULL,
164: 'LOAD',
165: USERENV('LANG')
166: FROM fem_entities_b fev_p,
167: fem_entities_b fev_c,
168: gcs_cons_relationships gcr
169: WHERE gcr.hierarchy_id = p_hierarchy_id
170: AND gcr.parent_entity_id = fev_p.entity_id

Line 167: fem_entities_b fev_c,

163: NULL,
164: 'LOAD',
165: USERENV('LANG')
166: FROM fem_entities_b fev_p,
167: fem_entities_b fev_c,
168: gcs_cons_relationships gcr
169: WHERE gcr.hierarchy_id = p_hierarchy_id
170: AND gcr.parent_entity_id = fev_p.entity_id
171: AND l_start_date BETWEEN gcr.start_date AND NVL(gcr.end_date, l_start_date)