DBA Data[Home] [Help]

APPS.GCS_DP_DYNAMIC_PKG dependencies on FEM_DATA_LOCATIONS

Line 690: FROM fem_data_locations fdl,

686: fnd_log.STRING (fnd_log.level_statement,
687: g_pkg_name || '.' || l_api_name,
688: 'SELECT cpmgt.source_cal_period_id cal_period_id
689: BULK COLLECT INTO l_periods_list
690: FROM fem_data_locations fdl,
691: gcs_cal_period_maps_gt cpmgt
692: WHERE fdl.ledger_id = ' ||p_source_ledger_id||'
693: AND fdl.cal_period_id = cpmgt.source_cal_period_id
694: AND fdl.source_system_code = '||l_source_system_code||'

Line 701: FROM fem_data_locations fdl,

697: END IF;
698:
699: SELECT cpmgt.source_cal_period_id cal_period_id
700: BULK COLLECT INTO l_periods_list
701: FROM fem_data_locations fdl,
702: gcs_cal_period_maps_gt cpmgt
703: WHERE fdl.ledger_id = p_source_ledger_id
704: AND fdl.cal_period_id = cpmgt.source_cal_period_id
705: AND fdl.source_system_code = l_source_system_code