APPS.GCS_DATA_PREP_PKG dependencies on FEM_DATA_LOCATIONS

Line 217: FROM fem_data_locations fdl, ' || '

213: g_pkg_name || '.' || l_api_name,
214: 'INSERT INTO gcs_cal_period_maps_gt (source_cal_period_id, target_cal_period_id)
215: SELECT fdl.cal_period_id, ' ||
216: p_target_cal_period_id || '
217: FROM fem_data_locations fdl, ' || '
218: fem_ledgers_attr fla, ' || '
219: fem_cal_periods_attr fcpa_number, ' || '
220: fem_cal_periods_attr fcpa_year, ' || '
221: gcs_cal_period_map_dtls gcpmd, ' || '

Line 277: FROM fem_data_locations fdl,

273:
274: INSERT INTO gcs_cal_period_maps_gt
275: (source_cal_period_id, target_cal_period_id)
276: SELECT fdl.cal_period_id, p_target_cal_period_id
277: FROM fem_data_locations fdl,
278: fem_ledgers_attr fla,
279: fem_cal_periods_attr fcpa_number,
280: fem_cal_periods_attr fcpa_year,
281: gcs_cal_period_map_dtls gcpmd,

Line 2074: FROM fem_data_locations fdl,

2070: fnd_log.STRING (fnd_log.level_statement,
2071: g_pkg_name || ''.'' || l_api_name,
2072: ''SELECT cpmgt.source_cal_period_id cal_period_id
2073: BULK COLLECT INTO l_periods_list
2074: FROM fem_data_locations fdl,
2075: gcs_cal_period_maps_gt cpmgt
2076: WHERE fdl.ledger_id = '' ||p_source_ledger_id||''
2077: AND fdl.cal_period_id = cpmgt.source_cal_period_id
2078: AND fdl.source_system_code = ''||l_source_system_code||''

Line 2085: FROM fem_data_locations fdl,

2081: END IF;
2082:
2083: SELECT cpmgt.source_cal_period_id cal_period_id
2084: BULK COLLECT INTO l_periods_list
2085: FROM fem_data_locations fdl,
2086: gcs_cal_period_maps_gt cpmgt
2087: WHERE fdl.ledger_id = p_source_ledger_id
2088: AND fdl.cal_period_id = cpmgt.source_cal_period_id
2089: AND fdl.source_system_code = l_source_system_code