DBA Data[Home] [Help]

APPS.FEM_DATA_LOADER_PKG dependencies on FEM_CALENDARS_B

Line 2539: FROM fem_calendars_b fcb,

2535:
2536: INSERT INTO fem_ld_cal_periods_gt(table_name, table_row, ledger_id, cal_period_id, dim_grp_id, valid)
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

Line 2568: FROM fem_calendars_b fcb,

2564:
2565: INSERT INTO fem_ld_cal_periods_gt(table_name, table_row, ledger_id, cal_period_id, dim_grp_id, valid)
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

Line 2596: FROM fem_calendars_b fcb,

2592:
2593: INSERT INTO fem_ld_cal_periods_gt(table_name, table_row, ledger_id, cal_period_id, dim_grp_id, valid)
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,

Line 2626: FROM fem_calendars_b fcb,

2622:
2623: INSERT INTO fem_ld_cal_periods_gt(table_name, table_row, ledger_id, cal_period_id, dim_grp_id, valid)
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,