APPS.IGS_AD_PS_APPL_INST_PKG dependencies on IGS_AD_PS_APPL_ALL

Line 463: FROM IGS_AD_PS_APPL_ALL apl

459:
460: --- begin apadegal ADTD001 RE-OPEN Build igs.m
461: CURSOR cur_reconsider IS
462: SELECT req_for_reconsideration_ind
463: FROM IGS_AD_PS_APPL_ALL apl
464: WHERE apl.person_id = new_references.person_id
465: AND apl.admission_appl_number = new_references.admission_appl_number
466: AND apl.nominated_course_cd = new_references.nominated_course_cd ;
467:

Line 4416: FROM IGS_AD_PS_APPL_ALL apl

4412:
4413: --- begin apadegal ADTD001 RE-OPEN Build igs.m
4414: CURSOR cur_reconsider IS
4415: SELECT req_for_reconsideration_ind
4416: FROM IGS_AD_PS_APPL_ALL apl
4417: WHERE apl.person_id = new_references.person_id
4418: AND apl.admission_appl_number = new_references.admission_appl_number
4419: AND apl.nominated_course_cd = new_references.nominated_course_cd ;
4420:

Line 4743: FROM IGS_AD_PS_APPL_ALL

4739:
4740: CURSOR c_recon_flag (cp_person_id IN NUMBER, cp_adm_application_num IN NUMBER,
4741: cp_nomintaed_course_code IN VARCHAR2) IS
4742: SELECT REQ_FOR_RECONSIDERATION_IND
4743: FROM IGS_AD_PS_APPL_ALL
4744: WHERE PERSON_ID = cp_person_id
4745: AND ADMISSION_APPL_NUMBER = cp_adm_application_num
4746: AND NOMINATED_COURSE_CD = cp_nomintaed_course_code;
4747:

Line 4748: l_req_for_reconsideration_ind IGS_AD_PS_APPL_ALL.REQ_FOR_RECONSIDERATION_IND%TYPE;

4744: WHERE PERSON_ID = cp_person_id
4745: AND ADMISSION_APPL_NUMBER = cp_adm_application_num
4746: AND NOMINATED_COURSE_CD = cp_nomintaed_course_code;
4747:
4748: l_req_for_reconsideration_ind IGS_AD_PS_APPL_ALL.REQ_FOR_RECONSIDERATION_IND%TYPE;
4749: -- end ravi shar changes
4750:
4751: -- kamohan Bug 2407628
4752: -- Added in order to avoid the hit to the database every time the records are looped through