APPS.IGS_AD_IMP_OFF_RESP_DATA dependencies on IGS_AD_PRD_AD_PRC_CA

Line 275: igs_ad_prd_ad_prc_ca apapc,

271: FROM
272: igs_ca_inst_alt_v acad_ciav,
273: igs_ca_inst_alt_v adm_ciav,
274: igs_ca_inst_rel cir,
275: igs_ad_prd_ad_prc_ca apapc,
276: igs_ca_type ct
277: WHERE
278: (acad_ciav.s_cal_cat = 'ACADEMIC' AND
279: acad_ciav.s_cal_status = 'ACTIVE' AND

Line 319: FROM igs_ad_prd_ad_prc_ca apapc,

315: AND ciav1.start_dt > cp_adm_ci_end_dt
316: AND (ciav1.cal_type, ciav1.sequence_number) IN
317: (SELECT apapc.adm_cal_type,
318: apapc.adm_ci_sequence_number
319: FROM igs_ad_prd_ad_prc_ca apapc,
320: igs_ca_inst_rel cir
321: WHERE apapc.admission_cat = cp_admission_cat AND
322: apapc.s_admission_process_type =cp_s_adm_process_type AND
323: cir.sub_cal_type = apapc.adm_cal_type AND

Line 343: FROM igs_ad_prd_ad_prc_ca admprd,

339: -- Following cursors added as part of Single Response build Bug:3132406
340: CURSOR get_single_response (p_admission_cat igs_ad_appl_all.admission_cat%TYPE,
341: p_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE) IS
342: SELECT admprd.single_response_flag
343: FROM igs_ad_prd_ad_prc_ca admprd,
344: igs_ad_appl_all appl,
345: igs_ad_ps_appl_inst_all aplinst
346: WHERE appl.person_id = p_person_id
347: AND appl.admission_appl_number = p_admission_appl_number

Line 360: igs_ad_prd_ad_prc_ca admprd

356: CURSOR get_aplinst_response_accepted IS
357: SELECT distinct appl.application_id, aplinst.nominated_course_cd
358: FROM igs_ad_appl_all appl,
359: igs_ad_ps_appl_inst aplinst,
360: igs_ad_prd_ad_prc_ca admprd
361: WHERE appl.person_id = aplinst.person_id
362: AND appl.admission_appl_number = aplinst.admission_appl_number
363: AND appl.person_id = p_person_id
364: AND igs_ad_gen_009.admp_get_sys_aors(aplinst.adm_offer_resp_status) = 'ACCEPTED'

Line 415: l_single_response_flag igs_ad_prd_ad_prc_ca.single_response_flag%TYPE;

411: v_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE;
412: v_appl_dt igs_ad_appl.appl_dt%TYPE;
413: v_adm_appl_status igs_ad_appl.adm_appl_status%TYPE;
414: v_adm_fee_status igs_ad_appl.adm_fee_status%TYPE;
415: l_single_response_flag igs_ad_prd_ad_prc_ca.single_response_flag%TYPE;
416: l_application_id igs_ad_appl_all.application_id%TYPE;
417: l_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE;
418: l_acad_alt_code igs_ca_inst.alternate_code%TYPE;
419: l_adm_alt_code igs_ca_inst.alternate_code%TYPE;