APPS.FEM_DIM_MEMBER_LOADER_PKG dependencies on FEM_CALENDARS_B

Line 2496: ' WHERE NOT EXISTS (SELECT 0 FROM fem_calendars_b C2'||

2492: -- of the CAL_PERIOD cursors
2493: ----------------------------------------------------------------
2494: x_special_calp_status_stmt := 'UPDATE fem_cal_periods_attr_t B'||
2495: ' SET status = ''INVALID_CALENDAR'''||
2496: ' WHERE NOT EXISTS (SELECT 0 FROM fem_calendars_b C2'||
2497: ' WHERE C2.calendar_display_code = B.calendar_display_code)'||
2498: ' AND {{data_slice}} '||
2499: ' AND B.STATUS'||p_exec_mode_clause;
2500:

Line 2519: ' AND EXISTS (SELECT 0 FROM FEM_CALENDARS_B C3'||

2515: ' SET status = ''INVALID_DIMENSION_GROUP'''||
2516: ' WHERE NOT EXISTS (SELECT 0 FROM fem_dimension_grps_b D2'||
2517: ' WHERE D2.dimension_group_display_code = B.dimension_group_display_code)'||
2518: ' AND {{data_slice}} '||
2519: ' AND EXISTS (SELECT 0 FROM FEM_CALENDARS_B C3'||
2520: ' WHERE C3.calendar_display_code = B.calendar_display_code)'||
2521: ' AND B.STATUS'||p_exec_mode_clause;
2522: IF p_data_slc IS NOT NULL THEN
2523: x_special_calp_status_stmt := REPLACE(x_special_calp_status_stmt,'{{data_slice}}',p_data_slc);

Line 8362: v_calp_from_cond := ',fem_calendars_b C, fem_dimension_grps_b D';

8358:
8359: IF p_dimension_varchar_label = 'CAL_PERIOD' AND
8360: p_load_type NOT IN ('DIMENSION_GROUP') THEN
8361:
8362: v_calp_from_cond := ',fem_calendars_b C, fem_dimension_grps_b D';
8363:
8364: x_update_stmt := 'UPDATE '||p_source_tl_table||' B'||
8365: ' SET B.status = ''READ_ONLY_MEMBER'' '||
8366: ' WHERE B.language IN '||

Line 8789: FROM fem_calendars_b

8785:
8786: BEGIN
8787: SELECT calendar_id
8788: INTO v_calendar_id
8789: FROM fem_calendars_b
8790: WHERE calendar_display_code = p_calendar_dc;
8791: EXCEPTION
8792: WHEN no_data_found THEN x_record_status := 'INVALID_CALPATTR_CALENDAR';
8793: END;

Line 11558: ', fem_calendars_b C, fem_dimension_grps_b D'||

11554: x_bad_member_select_stmt :=
11555: 'SELECT B.rowid'||
11556: ',''MISSING_NAME'''||
11557: ' FROM '||p_source_b_table||' B'||
11558: ', fem_calendars_b C, fem_dimension_grps_b D'||
11559: ' WHERE B.status'||p_exec_mode_clause||
11560: ' AND B.calendar_display_code = C.calendar_display_code'||
11561: ' AND B.dimension_group_display_code = D.dimension_group_display_code'||
11562:

Line 12730: ', FEM_CALENDARS_B C'||

12726: ',null'||
12727: ',null'||
12728: ', ''LOAD'' '||
12729: ' FROM '||p_source_b_table||' B'||
12730: ', FEM_CALENDARS_B C'||
12731: ', FEM_DIMENSION_GRPS_B D'||
12732: ' WHERE B.calendar_display_code = C.calendar_display_code'||
12733: ' AND B.dimension_group_display_code = D.dimension_group_display_code'||
12734: ' AND EXISTS (SELECT 0'||