APPS.IGS_AD_GEN_003 dependencies on IGS_AD_PECRS_OFOP_DT

Line 223: v_dai_sequence_number IGS_AD_PECRS_OFOP_DT.dai_sequence_number%TYPE;

219: DECLARE
220: v_sacc_due_dt_alias IGS_AD_CAL_CONF.adm_appl_due_dt_alias%TYPE;
221: v_sacc_final_dt_alias IGS_AD_CAL_CONF.adm_appl_final_dt_alias%TYPE;
222: v_daiv_alias_val DATE;
223: v_dai_sequence_number IGS_AD_PECRS_OFOP_DT.dai_sequence_number%TYPE;
224: v_apcood_found BOOLEAN;
225: v_curr_component_ctr NUMBER;
226: v_high_component_ctr NUMBER;
227: CURSOR c_sacc IS

Line 244: FROM IGS_AD_PECRS_OFOP_DT apcood

240: apac.adm_cal_type = daiv.cal_type AND
241: apac.adm_ci_sequence_number = daiv.ci_sequence_number AND
242: NOT EXISTS(
243: SELECT 'x'
244: FROM IGS_AD_PECRS_OFOP_DT apcood
245: WHERE apcood.adm_cal_type = apac.adm_cal_type AND
246: apcood.adm_ci_sequence_number = apac.adm_ci_sequence_number AND
247: apcood.dt_alias = daiv.dt_alias AND
248: apcood.dai_sequence_number = daiv.sequence_number)

Line 266: FROM IGS_AD_PECRS_OFOP_DT apcood

262: apcood.location_cd,
263: apcood.attendance_mode,
264: apcood.attendance_type,
265: apcood.dai_sequence_number
266: FROM IGS_AD_PECRS_OFOP_DT apcood
267: WHERE apcood.adm_cal_type = p_adm_cal_type AND
268: apcood.adm_ci_sequence_number = p_adm_ci_sequence_number AND
269: apcood.admission_cat = p_admission_cat AND
270: apcood.dt_alias = p_dt_alias;