DBA Data[Home] [Help]

APPS.GCS_DP_DYNAMIC_PKG dependencies on GCS_CAL_PERIOD_MAPS_GT

Line 691: gcs_cal_period_maps_gt cpmgt

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||'
695: AND fdl.dataset_code = ' ||p_source_dataset_code||'

Line 702: gcs_cal_period_maps_gt cpmgt

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
706: AND fdl.dataset_code = p_source_dataset_code