APPS.FEM_DATA_LOADER_PKG dependencies on FEM_DIMENSIONS_B

Line 619: FROM fem_dimensions_b

615:
616: BEGIN
617: SELECT dimension_id
618: INTO g_ledger_dim_id
619: FROM fem_dimensions_b
620: WHERE dimension_varchar_label = 'LEDGER';
621: EXCEPTION
622: WHEN OTHERS THEN
623: fem_engines_pkg.tech_message (p_severity => g_log_level_6

Line 661: FROM fem_dimensions_b

657:
658: BEGIN
659: SELECT dimension_id
660: INTO g_cal_period_dim_id
661: FROM fem_dimensions_b
662: WHERE dimension_varchar_label = 'CAL_PERIOD';
663: EXCEPTION
664: WHEN OTHERS THEN
665: fem_engines_pkg.tech_message (p_severity => g_log_level_6

Line 726: FROM fem_dimensions_b

722:
723: BEGIN
724: SELECT dimension_id
725: INTO g_dataset_dim_id
726: FROM fem_dimensions_b
727: WHERE dimension_varchar_label = 'DATASET';
728: EXCEPTION
729: WHEN OTHERS THEN
730: fem_engines_pkg.tech_message (p_severity => g_log_level_6

Line 792: FROM fem_dimensions_b dim

788:
789: BEGIN
790: SELECT dim.dimension_id
791: INTO g_budget_dim_id
792: FROM fem_dimensions_b dim
793: WHERE dim.dimension_varchar_label = 'BUDGET';
794: EXCEPTION
795: WHEN OTHERS THEN
796: fem_engines_pkg.tech_message (p_severity => g_log_level_6

Line 1567: fem_dimensions_b fdb,

1563: intf_member_b_table_name,
1564: TO_NUMBER(NULL),
1565: 'N'
1566: FROM fem_tab_columns_b ftcb,
1567: fem_dimensions_b fdb,
1568: fem_xdim_dimensions fxd
1569: WHERE table_name = gs_table_name_tab(i)
1570: AND fem_data_type_code = 'DIMENSION'
1571: AND fdb.dimension_id = ftcb.dimension_id