APPS.GCS_DYN_FEM_POSTING_PKG dependencies on GCS_HIERARCHIES_B

Line 828: FROM GCS_HIERARCHIES_B

824:
825: -- get ledger_id
826: SELECT fem_ledger_id
827: INTO l_ledger_id
828: FROM GCS_HIERARCHIES_B
829: WHERE hierarchy_id = p_hierarchy_id;
830:
831: -- Get current and previous period information.
832: GCS_UTILITY_PKG.get_cal_period_details(p_cal_period_id, l_cal_period_info);

Line 846: FROM gcs_hierarchies_b

842: -- Bugfix 5646770: Add check to determine if its the topmost entity
843: IF (p_category_code = 'AGGREGATION') THEN
844: SELECT DECODE(top_entity_id, p_cons_entity_id, 'Y', 'N')
845: INTO l_topmost_entity_flag
846: FROM gcs_hierarchies_b
847: WHERE hierarchy_id = p_hierarchy_id;
848: END IF;
849:
850: BEGIN

Line 1013: FROM gcs_hierarchies_b ghb

1009:
1010: -- Get the ledger_id
1011: SELECT ghb.fem_ledger_id
1012: INTO l_ledger_id
1013: FROM gcs_hierarchies_b ghb
1014: WHERE ghb.hierarchy_id = p_hierarchy_id;
1015:
1016: -- 'E' is for consolidation entities
1017: IF p_entity_type = 'E' THEN