eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GCS_DATA_PREP_PKG dependencies on FEM_CAL_PERIODS_B

Line 130: FROM gcs_data_sub_dtls gdsd, fem_cal_periods_b fcpb

126: END IF;
127:
128: SELECT gdsd.cal_period_id, fcpb.calendar_id, fcpb.dimension_group_id
129: INTO l_src_cal_period_id, l_src_calendar_id, l_src_dimension_grp_id
130: FROM gcs_data_sub_dtls gdsd, fem_cal_periods_b fcpb
131: WHERE gdsd.entity_id = p_entity_id
132: AND gdsd.balance_type_code = p_balance_type_code
133: AND gdsd.cal_period_id = fcpb.cal_period_id
134: AND ROWNUM < 2;

Line 138: FROM fem_cal_periods_b fcpb

134: AND ROWNUM < 2;
135:
136: SELECT fcpb.calendar_id, fcpb.dimension_group_id
137: INTO l_tgt_calendar_id, l_tgt_dimension_grp_id
138: FROM fem_cal_periods_b fcpb
139: WHERE fcpb.cal_period_id = p_target_cal_period_id;
140:
141: IF ((l_src_calendar_id = l_tgt_calendar_id) AND
142: (l_src_dimension_grp_id = l_tgt_dimension_grp_id)) THEN

Line 223: fem_cal_periods_b fcpb_src, ' || '

219: fem_cal_periods_attr fcpa_number, ' || '
220: fem_cal_periods_attr fcpa_year, ' || '
221: gcs_cal_period_map_dtls gcpmd, ' || '
222: gcs_cal_period_maps gcpm, ' || '
223: fem_cal_periods_b fcpb_src, ' || '
224: fem_cal_periods_b fcpb_tgt ' || '
225: WHERE fdl.ledger_id = ' ||
226: p_source_ledger_id || '
227: AND fdl.table_name = ''FEM_BALANCES'' ' || '

Line 224: fem_cal_periods_b fcpb_tgt ' || '

220: fem_cal_periods_attr fcpa_year, ' || '
221: gcs_cal_period_map_dtls gcpmd, ' || '
222: gcs_cal_period_maps gcpm, ' || '
223: fem_cal_periods_b fcpb_src, ' || '
224: fem_cal_periods_b fcpb_tgt ' || '
225: WHERE fdl.ledger_id = ' ||
226: p_source_ledger_id || '
227: AND fdl.table_name = ''FEM_BALANCES'' ' || '
228: AND fdl.load_status = ''COMPLETE''

Line 283: fem_cal_periods_b fcpb_src,

279: fem_cal_periods_attr fcpa_number,
280: fem_cal_periods_attr fcpa_year,
281: gcs_cal_period_map_dtls gcpmd,
282: gcs_cal_period_maps gcpm,
283: fem_cal_periods_b fcpb_src,
284: fem_cal_periods_b fcpb_tgt
285: WHERE fdl.ledger_id = p_source_ledger_id
286: AND fdl.table_name = 'FEM_BALANCES'
287: AND fdl.load_status = 'COMPLETE'

Line 284: fem_cal_periods_b fcpb_tgt

280: fem_cal_periods_attr fcpa_year,
281: gcs_cal_period_map_dtls gcpmd,
282: gcs_cal_period_maps gcpm,
283: fem_cal_periods_b fcpb_src,
284: fem_cal_periods_b fcpb_tgt
285: WHERE fdl.ledger_id = p_source_ledger_id
286: AND fdl.table_name = 'FEM_BALANCES'
287: AND fdl.load_status = 'COMPLETE'
288: AND fdl.balance_type_code = p_balance_type_code

Line 349: fem_cal_periods_b fcpb_src,

345: INTO p_year_end_values_match
346: FROM gcs_cal_period_map_dtls gcpmd,
347: gcs_cal_period_maps_gt gcpmg,
348: gcs_cal_period_maps gcpm,
349: fem_cal_periods_b fcpb_src,
350: fem_cal_periods_b fcpb_tgt
351: WHERE gcpmd.cal_period_map_id = gcpm.cal_period_map_id
352: AND gcpmd.target_relative_year_code <> ''CURRENT''
353: AND fcpb_src.cal_period_id = gcpmg.source_cal_period_id

Line 350: fem_cal_periods_b fcpb_tgt

346: FROM gcs_cal_period_map_dtls gcpmd,
347: gcs_cal_period_maps_gt gcpmg,
348: gcs_cal_period_maps gcpm,
349: fem_cal_periods_b fcpb_src,
350: fem_cal_periods_b fcpb_tgt
351: WHERE gcpmd.cal_period_map_id = gcpm.cal_period_map_id
352: AND gcpmd.target_relative_year_code <> ''CURRENT''
353: AND fcpb_src.cal_period_id = gcpmg.source_cal_period_id
354: AND gcpm.source_calendar_id = fcpb_src.calendar_id

Line 366: fem_cal_periods_b fcpb_src,

362: INTO p_year_end_values_match
363: FROM gcs_cal_period_map_dtls gcpmd,
364: gcs_cal_period_maps_gt gcpmg,
365: gcs_cal_period_maps gcpm,
366: fem_cal_periods_b fcpb_src,
367: fem_cal_periods_b fcpb_tgt
368: WHERE gcpmd.cal_period_map_id = gcpm.cal_period_map_id
369: AND gcpmd.target_relative_year_code <> 'CURRENT'
370: AND fcpb_src.cal_period_id = gcpmg.source_cal_period_id

Line 367: fem_cal_periods_b fcpb_tgt

363: FROM gcs_cal_period_map_dtls gcpmd,
364: gcs_cal_period_maps_gt gcpmg,
365: gcs_cal_period_maps gcpm,
366: fem_cal_periods_b fcpb_src,
367: fem_cal_periods_b fcpb_tgt
368: WHERE gcpmd.cal_period_map_id = gcpm.cal_period_map_id
369: AND gcpmd.target_relative_year_code <> 'CURRENT'
370: AND fcpb_src.cal_period_id = gcpmg.source_cal_period_id
371: AND gcpm.source_calendar_id = fcpb_src.calendar_id

Line 475: fem_cal_periods_b fcpb

471: g_pkg_name || '.' || l_api_name,
472: ' SELECT gcpm.cal_period_map_id
473: INTO l_cal_period_map_id
474: FROM gcs_cal_period_maps gcpm,
475: fem_cal_periods_b fcpb
476: WHERE gcpm.target_calendar_id = ' ||
477: l_calendar_id || '
478: AND gcpm.target_dimension_group_id = ' ||
479: l_dimension_grp_id || '

Line 488: FROM gcs_cal_period_maps gcpm, fem_cal_periods_b fcpb

484: END IF;
485:
486: SELECT gcpm.cal_period_map_id
487: INTO l_cal_period_map_id
488: FROM gcs_cal_period_maps gcpm, fem_cal_periods_b fcpb
489: WHERE gcpm.target_calendar_id = l_calendar_id
490: AND gcpm.target_dimension_group_id = l_dimension_grp_id
491: AND fcpb.cal_period_id = p_source_cal_period_id
492: AND gcpm.source_calendar_id = fcpb.calendar_id

Line 503: FROM fem_cal_periods_b fcpb,

499: fnd_log.STRING(fnd_log.level_statement,
500: g_pkg_name || '.' || l_api_name,
501: 'INSERT INTO gcs_cal_period_maps_gt (source_cal_period_id, target_cal_period_id)
502: SELECT fcpb.cal_period_id, p_source_cal_period_id
503: FROM fem_cal_periods_b fcpb,
504: fem_cal_periods_attr fcpa_number,
505: fem_cal_periods_attr fcpa_year,
506: gcs_cal_period_map_dtls gcpmd
507: WHERE gcpmd.cal_period_map_id = ' ||

Line 543: FROM fem_cal_periods_b fcpb,

539:
540: INSERT INTO gcs_cal_period_maps_gt
541: (source_cal_period_id, target_cal_period_id)
542: SELECT p_source_cal_period_id, fcpb.cal_period_id
543: FROM fem_cal_periods_b fcpb,
544: fem_cal_periods_attr fcpa_number,
545: fem_cal_periods_attr fcpa_year,
546: gcs_cal_period_map_dtls gcpmd
547: WHERE gcpmd.cal_period_map_id = l_cal_period_map_id