APPS.AHL_RA_ANALYSER_PVT dependencies on AHL_RA_FCT_ASSOCIATIONS

Line 214: CURSOR c_fetch_dummy_assocs(c_fct_designator AHL_RA_FCT_ASSOCIATIONS.FORECAST_DESIGNATOR%TYPE,

210: and pos.sequence in (select max(sequence)
211: from ahl_mc_path_position_nodes
212: where path_position_id = pos.path_position_id);
213:
214: CURSOR c_fetch_dummy_assocs(c_fct_designator AHL_RA_FCT_ASSOCIATIONS.FORECAST_DESIGNATOR%TYPE,
215: c_arrival_org_id AHL_RA_FCT_ASSOCIATIONS.ORGANIZATION_ID%TYPE) IS
216: Select FORECAST_DESIGNATOR
217: from AHL_RA_FCT_ASSOCIATIONS
218: where ASSOCIATION_TYPE_CODE = 'ASSOC_HISTORICAL'

Line 215: c_arrival_org_id AHL_RA_FCT_ASSOCIATIONS.ORGANIZATION_ID%TYPE) IS

211: from ahl_mc_path_position_nodes
212: where path_position_id = pos.path_position_id);
213:
214: CURSOR c_fetch_dummy_assocs(c_fct_designator AHL_RA_FCT_ASSOCIATIONS.FORECAST_DESIGNATOR%TYPE,
215: c_arrival_org_id AHL_RA_FCT_ASSOCIATIONS.ORGANIZATION_ID%TYPE) IS
216: Select FORECAST_DESIGNATOR
217: from AHL_RA_FCT_ASSOCIATIONS
218: where ASSOCIATION_TYPE_CODE = 'ASSOC_HISTORICAL'
219: and FORECAST_DESIGNATOR <> c_fct_designator

Line 217: from AHL_RA_FCT_ASSOCIATIONS

213:
214: CURSOR c_fetch_dummy_assocs(c_fct_designator AHL_RA_FCT_ASSOCIATIONS.FORECAST_DESIGNATOR%TYPE,
215: c_arrival_org_id AHL_RA_FCT_ASSOCIATIONS.ORGANIZATION_ID%TYPE) IS
216: Select FORECAST_DESIGNATOR
217: from AHL_RA_FCT_ASSOCIATIONS
218: where ASSOCIATION_TYPE_CODE = 'ASSOC_HISTORICAL'
219: and FORECAST_DESIGNATOR <> c_fct_designator
220: and ORGANIZATION_ID = c_arrival_org_id;
221:

Line 1078: from AHL_RA_FCT_ASSOCIATIONS

1074:
1075: BEGIN
1076: Select FORECAST_DESIGNATOR
1077: into l_fct_designator
1078: from AHL_RA_FCT_ASSOCIATIONS
1079: where ASSOCIATION_TYPE_CODE = 'ASSOC_MTBF'
1080: and ORGANIZATION_ID = l_fs_arr_org_id_tbl(i);
1081:
1082: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 1392: from AHL_RA_FCT_ASSOCIATIONS

1388: fnd_file.put_line(fnd_file.log, ' ----No MTBF Data Found -- Retreive Forecast Designator ----');
1389: END IF;
1390: Select FORECAST_DESIGNATOR
1391: into l_fct_designator
1392: from AHL_RA_FCT_ASSOCIATIONS
1393: where ASSOCIATION_TYPE_CODE = 'ASSOC_HISTORICAL'
1394: and PROBABILITY_FROM <= l_prob_value
1395: and ( PROBABILITY_TO > l_prob_value
1396: OR (l_prob_value = 100 AND PROBABILITY_TO >= l_prob_value))