APPS.IGS_AD_GEN_007 dependencies on IGS_AD_PECRS_OFOP_DT

Line 409: v_dai_sequence_number IGS_AD_PECRS_OFOP_DT.dai_sequence_number%TYPE ;

405: v_appl_offer_resp_dt_alias IGS_AD_CAL_CONF.adm_appl_offer_resp_dt_alias%TYPE;
406: v_offer_resp_dt_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
407: v_offer_resp_dt DATE;
408: v_apc_found BOOLEAN;
409: v_dai_sequence_number IGS_AD_PECRS_OFOP_DT.dai_sequence_number%TYPE ;
410: v_apcood_found BOOLEAN := FALSE;
411: v_curr_component_ctr NUMBER := 0;
412: v_high_component_ctr NUMBER := 0;
413:

Line 437: FROM IGS_AD_PECRS_OFOP_DT apcood

433: apcood.location_cd,
434: apcood.attendance_mode,
435: apcood.attendance_type,
436: apcood.dai_sequence_number
437: FROM IGS_AD_PECRS_OFOP_DT apcood
438: WHERE apcood.adm_cal_type = p_adm_cal_type AND
439: apcood.adm_ci_sequence_number = p_adm_ci_sequence_number AND
440: apcood.admission_cat = p_admission_cat AND
441: apcood.dt_alias = cp_appl_offer_resp_dt_alias;

Line 455: FROM IGS_AD_PECRS_OFOP_DT apcood

451: apac.adm_cal_type = daiv.cal_type AND
452: apac.adm_ci_sequence_number = daiv.ci_sequence_number AND
453: NOT EXISTS(
454: SELECT 'x'
455: FROM IGS_AD_PECRS_OFOP_DT apcood
456: WHERE apcood.adm_cal_type = apac.adm_cal_type AND
457: apcood.adm_ci_sequence_number = apac.adm_ci_sequence_number AND
458: apcood.dt_alias = daiv.dt_alias AND
459: apcood.dai_sequence_number = daiv.sequence_number)