APPS.IGS_FI_PRC_STDNT_DPSTS dependencies on IGS_AD_APPL

Line 1061: cp_n_appl_id igs_ad_appl.application_id%TYPE)

1057: -- Get the Admission Application Number for the Admission Application Id
1058: -- With an Admission Application Id, a unique Admission Application Number can be identified for a
1059: -- person incontext
1060: CURSOR c_adm_appl_number(cp_n_person_id igs_fi_parties_v.person_id%TYPE,
1061: cp_n_appl_id igs_ad_appl.application_id%TYPE)
1062: IS
1063: SELECT admission_appl_number, application_type
1064: FROM igs_ad_appl
1065: WHERE person_id = cp_n_person_id AND

Line 1064: FROM igs_ad_appl

1060: CURSOR c_adm_appl_number(cp_n_person_id igs_fi_parties_v.person_id%TYPE,
1061: cp_n_appl_id igs_ad_appl.application_id%TYPE)
1062: IS
1063: SELECT admission_appl_number, application_type
1064: FROM igs_ad_appl
1065: WHERE person_id = cp_n_person_id AND
1066: (application_id IS NOT NULL AND application_id = cp_n_appl_id);
1067: l_rec_adm_appl_number c_adm_appl_number%ROWTYPE;
1068:

Line 1070: CURSOR c_deposit_level( cp_c_application_type IN igs_ad_appl.application_type%TYPE)

1066: (application_id IS NOT NULL AND application_id = cp_n_appl_id);
1067: l_rec_adm_appl_number c_adm_appl_number%ROWTYPE;
1068:
1069: -- Cursor for fetching the deposit level for an Admission Application Type
1070: CURSOR c_deposit_level( cp_c_application_type IN igs_ad_appl.application_type%TYPE)
1071: IS
1072: SELECT NVL(enroll_deposit_level, g_c_appl_dep_lvl) enroll_deposit_level
1073: FROM igs_ad_ss_appl_typ
1074: WHERE admission_application_type = cp_c_application_type AND

Line 1095: igs_ad_appl aa,

1091: SELECT inst.course_cd course_cd,
1092: inst.crv_version_number version_number,
1093: ps.course_type course_type
1094: FROM igs_ad_ps_appl_inst inst,
1095: igs_ad_appl aa,
1096: igs_ps_ver ps,
1097: igs_ad_ofrdfrmt_stat df,
1098: igs_ad_ofr_resp_stat off
1099: WHERE inst.person_id = cp_n_person_id AND