APPS.IGS_AD_UPD_INITIALISE dependencies on IGS_AD_APPL

Line 173: FROM igs_ad_ps_appl_inst a, igs_ad_appl b

169: cp_admission_appl_number IN igs_ad_ps_appl_inst. admission_appl_number%TYPE,
170: cp_nominated_course_cd IN igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
171: cp_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE) IS
172: SELECT a.enrolment_cat,b.acad_cal_type,b.acad_ci_sequence_number
173: FROM igs_ad_ps_appl_inst a, igs_ad_appl b
174: WHERE a.person_id = cp_person_id
175: AND a.admission_appl_number = cp_admission_appl_number
176: AND a.nominated_course_cd = cp_nominated_course_cd
177: AND a.sequence_number=cp_sequence_number

Line 403: ELSIF p_msg_name = 'IGS_AD_APPLFEES_OUTSTANDING' THEN

399: ELSIF p_msg_name = 'IGS_AD_OUTCOME_CANNOT_SETTO' THEN
400: RETURN 'E533';
401: ELSIF p_msg_name = 'IGS_AD_OUTCOME_FUTURE_TERM' THEN
402: RETURN 'E534';
403: ELSIF p_msg_name = 'IGS_AD_APPLFEES_OUTSTANDING' THEN
404: RETURN 'E535';
405: ELSIF p_msg_name = 'IGS_AD_INVALID_COND_OFFER' THEN
406: RETURN 'E536';
407: ELSIF p_msg_name = 'IGS_AD_ADMAPL_FEES_OUTSTANDIN' THEN

Line 511: igs_ad_appl_all apl

507: FROM
508: igs_ca_inst_rel car , -- calendar relations table
509: igs_ca_inst_all ca , -- calendar instances table
510: igs_ca_type cat, -- calendar types table
511: igs_ad_appl_all apl
512: WHERE
513: apl.person_id = p_person_id -- current person id
514: AND apl.admission_appl_number = p_admission_appl_number -- current adm appl number
515: AND car.sup_cal_type = apl.adm_cal_type

Line 547: FROM igs_ad_appl_all apl ,

543: IS
544: SELECT apl.adm_cal_type,
545: apl.adm_ci_sequence_number ,
546: ca.start_dt
547: FROM igs_ad_appl_all apl ,
548: igs_ad_ps_appl_inst_all inst,
549: igs_ca_inst_all ca
550: WHERE apl.person_id = P_PERSON_ID
551: AND apl.person_id = inst.person_id