APPS.GCS_DP_DYNAMIC_PKG dependencies on GCS_CONS_ENG_RUNS

Line 1145: FROM gcs_cons_eng_runs

1141: fnd_log.STRING (fnd_log.level_statement,
1142: g_pkg_name || '.' || l_api_name,
1143: ' SELECT decode(count(run_name), 0, ''Y'', ''N'')
1144: INTO l_first_ever_data_prepped
1145: FROM gcs_cons_eng_runs
1146: WHERE hierarchy_id = '||p_hierarchy_id||'
1147: AND run_entity_id = '||p_entity_id||'
1148: AND balance_type_code = '||p_balance_type_code||'
1149: AND (cal_period_id = '||p_cal_period_record.prev_cal_period_id||'

Line 1155: FROM gcs_cons_eng_runs

1151: AND status_code NOT IN (''NOT_STARTED'', ''IN_PROGRESS'')))');
1152: END IF;
1153: SELECT decode(count(run_name), 0, 'Y', 'N')
1154: INTO l_first_ever_data_prepped
1155: FROM gcs_cons_eng_runs
1156: WHERE hierarchy_id = p_hierarchy_id
1157: AND run_entity_id = p_entity_id
1158: AND balance_type_code = p_balance_type_code
1159: AND ( cal_period_id = p_cal_period_record.prev_cal_period_id

Line 1761: FROM gcs_cons_eng_runs

1757: WHERE child_entity_id = p_entity_id
1758: AND category_code = 'DATAPREPARATION'
1759: AND run_name in (
1760: SELECT nvl(associated_run_name, run_name)
1761: FROM gcs_cons_eng_runs
1762: WHERE hierarchy_id = p_hierarchy_id
1763: AND cal_period_id = p_target_cal_period_id
1764: AND balance_type_code = p_balance_type_code
1765: AND most_recent_flag = 'Y'