APPS.FEM_DATA_LOADER_PKG dependencies on FEM_CAL_PERIODS_B

Line 2541: fem_cal_periods_b fcpb

2537: SELECT gs_table_name_tab(i), gs_table_row_tab(i), gs_ledger_tab(i), fcpb.cal_period_id,
2538: fcpb.dimension_group_id, 'VALID'
2539: FROM fem_calendars_b fcb,
2540: fem_dimension_grps_b fdgb,
2541: fem_cal_periods_b fcpb
2542: WHERE fcpb.calendar_id = fcb.calendar_id
2543: AND fcpb.dimension_group_id = fdgb.dimension_group_id
2544: AND EXISTS ( SELECT 1
2545: FROM fem_ld_interface_data_gt idt

Line 2570: fem_cal_periods_b fcpb

2566: SELECT gs_table_name_tab(i), gs_table_row_tab(i), gs_ledger_tab(i), fcpb.cal_period_id,
2567: fcpb.dimension_group_id, 'VALID'
2568: FROM fem_calendars_b fcb,
2569: fem_dimension_grps_b fdgb,
2570: fem_cal_periods_b fcpb
2571: WHERE fcpb.calendar_id = fcb.calendar_id
2572: AND fcpb.dimension_group_id = fdgb.dimension_group_id
2573: AND EXISTS ( SELECT 1
2574: FROM fem_ld_interface_data_gt idt

Line 2598: fem_cal_periods_b fcpb,

2594: SELECT gs_table_name_tab(i), gs_table_row_tab(i), idt.ledger_id, fcpb.cal_period_id,
2595: fcpb.dimension_group_id, 'VALID'
2596: FROM fem_calendars_b fcb,
2597: fem_dimension_grps_b fdgb,
2598: fem_cal_periods_b fcpb,
2599: (SELECT DISTINCT ledger_id,
2600: dimension_group_id,
2601: calendar_id,
2602: cal_period

Line 2628: fem_cal_periods_b fcpb,

2624: SELECT gs_table_name_tab(i), gs_table_row_tab(i), idt.ledger_id, fcpb.cal_period_id,
2625: fcpb.dimension_group_id, 'VALID'
2626: FROM fem_calendars_b fcb,
2627: fem_dimension_grps_b fdgb,
2628: fem_cal_periods_b fcpb,
2629: (SELECT DISTINCT ledger_id,
2630: calendar_id,
2631: cal_period
2632: FROM fem_ld_interface_data_gt