APPS.FEM_INTG_CAL_RULE_ENG_PKG dependencies on FEM_DIMENSIONS_B

Line 637: FROM FEM_DIMENSIONS_B

633: -- Initialize other package level variables
634: --
635: SELECT DIMENSION_ID
636: INTO pv_ledger_dim_id
637: FROM FEM_DIMENSIONS_B
638: WHERE DIMENSION_VARCHAR_LABEL = 'LEDGER';
639:
640: SELECT DIMENSION_ID
641: INTO pv_calendar_dim_id

Line 642: FROM FEM_DIMENSIONS_B

638: WHERE DIMENSION_VARCHAR_LABEL = 'LEDGER';
639:
640: SELECT DIMENSION_ID
641: INTO pv_calendar_dim_id
642: FROM FEM_DIMENSIONS_B
643: WHERE DIMENSION_VARCHAR_LABEL = 'CALENDAR';
644:
645: SELECT DIMENSION_ID
646: INTO pv_cal_period_dim_id

Line 647: FROM FEM_DIMENSIONS_B

643: WHERE DIMENSION_VARCHAR_LABEL = 'CALENDAR';
644:
645: SELECT DIMENSION_ID
646: INTO pv_cal_period_dim_id
647: FROM FEM_DIMENSIONS_B
648: WHERE DIMENSION_VARCHAR_LABEL = 'CAL_PERIOD';
649:
650: SELECT DIMENSION_ID
651: INTO pv_time_group_type_dim_id

Line 652: FROM FEM_DIMENSIONS_B

648: WHERE DIMENSION_VARCHAR_LABEL = 'CAL_PERIOD';
649:
650: SELECT DIMENSION_ID
651: INTO pv_time_group_type_dim_id
652: FROM FEM_DIMENSIONS_B
653: WHERE DIMENSION_VARCHAR_LABEL = 'TIME_GROUP_TYPE';
654:
655: SELECT DIMENSION_GROUP_ID
656: INTO pv_dimension_grp_id_year