APPS.GCS_DATA_PREP_PKG dependencies on GCS_CONS_ENG_RUNS

Line 681: FROM gcs_cons_eng_runs gcer

677: WHERE gcerd.child_entity_id = p_entity_id
678: AND gcerd.category_code = 'DATAPREPARATION'
679: AND EXISTS
680: (SELECT 'X'
681: FROM gcs_cons_eng_runs gcer
682: WHERE gcer.run_name = gcerd.run_name
683: AND gcer.run_entity_id = gcerd.consolidation_entity_id
684: AND gcer.hierarchy_id = p_hierarchy_id
685: AND gcer.cal_period_id = p_prior_cal_period_id

Line 2356: FROM gcs_cons_eng_runs

2352: fnd_log.STRING (fnd_log.level_statement,
2353: g_pkg_name || ''.'' || l_api_name,
2354: '' SELECT decode(count(run_name), 0, ''''Y'''', ''''N'''')
2355: INTO l_first_ever_data_prepped
2356: FROM gcs_cons_eng_runs
2357: WHERE hierarchy_id = ''||p_hierarchy_id||''
2358: AND run_entity_id = ''||p_entity_id||''
2359: AND balance_type_code = ''||p_balance_type_code||''
2360: AND (cal_period_id = ''||p_cal_period_record.prev_cal_period_id||''

Line 2366: FROM gcs_cons_eng_runs

2362: AND status_code NOT IN (''''NOT_STARTED'''', ''''IN_PROGRESS'''')))'');
2363: END IF;
2364: SELECT decode(count(run_name), 0, ''Y'', ''N'')
2365: INTO l_first_ever_data_prepped
2366: FROM gcs_cons_eng_runs
2367: WHERE hierarchy_id = p_hierarchy_id
2368: AND run_entity_id = p_entity_id
2369: AND balance_type_code = p_balance_type_code
2370: AND ( cal_period_id = p_cal_period_record.prev_cal_period_id

Line 2915: FROM gcs_cons_eng_runs

2911: WHERE child_entity_id = p_entity_id
2912: AND category_code = ''DATAPREPARATION''
2913: AND run_name in (
2914: SELECT nvl(associated_run_name, run_name)
2915: FROM gcs_cons_eng_runs
2916: WHERE hierarchy_id = p_hierarchy_id
2917: AND cal_period_id = p_target_cal_period_id
2918: AND balance_type_code = p_balance_type_code
2919: AND most_recent_flag = ''Y''