eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_VAL_ACAI dependencies on IGS_AD_APPL

Line 64: v_s_adm_appl_status IGS_AD_APPL_STAT.s_adm_appl_status%TYPE;

60: cst_completed CONSTANT VARCHAR2(9) := 'COMPLETED';
61: cst_withdrawn CONSTANT VARCHAR2(9) := 'WITHDRAWN';
62: cst_warn CONSTANT VARCHAR2(1) := 'W';
63: cst_error CONSTANT VARCHAR2(1) := 'E';
64: v_s_adm_appl_status IGS_AD_APPL_STAT.s_adm_appl_status%TYPE;
65: v_message_name VARCHAR2(30);
66: v_return BOOLEAN := TRUE;
67: CURSOR c_acaiv (
68: cp_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,

Line 77: cp_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE,

73: cp_attendance_mode IGS_AD_PS_APPL_INST.attendance_mode%TYPE,
74: cp_attendance_type IGS_AD_PS_APPL_INST.attendance_type%TYPE,
75: cp_unit_set_cd IGS_AD_PS_APPL_INST.unit_set_cd%TYPE,
76: cp_us_version_number IGS_AD_PS_APPL_INST.us_version_number%TYPE,
77: cp_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE,
78: cp_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE) IS
79: SELECT 'x'
80: FROM IGS_AD_APPL aav, IGS_AD_PS_APPL_INST acaiv
81: WHERE aav.person_id = acaiv.person_id AND

Line 78: cp_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE) IS

74: cp_attendance_type IGS_AD_PS_APPL_INST.attendance_type%TYPE,
75: cp_unit_set_cd IGS_AD_PS_APPL_INST.unit_set_cd%TYPE,
76: cp_us_version_number IGS_AD_PS_APPL_INST.us_version_number%TYPE,
77: cp_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE,
78: cp_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE) IS
79: SELECT 'x'
80: FROM IGS_AD_APPL aav, IGS_AD_PS_APPL_INST acaiv
81: WHERE aav.person_id = acaiv.person_id AND
82: aav.admission_appl_number = acaiv.admission_appl_number AND

Line 80: FROM IGS_AD_APPL aav, IGS_AD_PS_APPL_INST acaiv

76: cp_us_version_number IGS_AD_PS_APPL_INST.us_version_number%TYPE,
77: cp_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE,
78: cp_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE) IS
79: SELECT 'x'
80: FROM IGS_AD_APPL aav, IGS_AD_PS_APPL_INST acaiv
81: WHERE aav.person_id = acaiv.person_id AND
82: aav.admission_appl_number = acaiv.admission_appl_number AND
83: acaiv.person_id = cp_person_id AND
84: acaiv.course_cd = cp_course_cd AND

Line 111: cp_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE,

107: cp_attendance_mode IGS_AD_PS_APPL_INST.attendance_mode%TYPE,
108: cp_attendance_type IGS_AD_PS_APPL_INST.attendance_type%TYPE,
109: cp_unit_set_cd IGS_AD_PS_APPL_INST.unit_set_cd%TYPE,
110: cp_us_version_number IGS_AD_PS_APPL_INST.us_version_number%TYPE,
111: cp_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE,
112: cp_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE,
113: cp_choice_number IGS_AD_APPL.choice_number%TYPE,
114: cp_alt_appl_id IGS_AD_APPL.alt_appl_id%TYPE) IS
115: SELECT 'x'

Line 112: cp_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE,

108: cp_attendance_type IGS_AD_PS_APPL_INST.attendance_type%TYPE,
109: cp_unit_set_cd IGS_AD_PS_APPL_INST.unit_set_cd%TYPE,
110: cp_us_version_number IGS_AD_PS_APPL_INST.us_version_number%TYPE,
111: cp_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE,
112: cp_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE,
113: cp_choice_number IGS_AD_APPL.choice_number%TYPE,
114: cp_alt_appl_id IGS_AD_APPL.alt_appl_id%TYPE) IS
115: SELECT 'x'
116: FROM IGS_AD_APPL aav, IGS_AD_PS_APPL_INST acaiv

Line 113: cp_choice_number IGS_AD_APPL.choice_number%TYPE,

109: cp_unit_set_cd IGS_AD_PS_APPL_INST.unit_set_cd%TYPE,
110: cp_us_version_number IGS_AD_PS_APPL_INST.us_version_number%TYPE,
111: cp_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE,
112: cp_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE,
113: cp_choice_number IGS_AD_APPL.choice_number%TYPE,
114: cp_alt_appl_id IGS_AD_APPL.alt_appl_id%TYPE) IS
115: SELECT 'x'
116: FROM IGS_AD_APPL aav, IGS_AD_PS_APPL_INST acaiv
117: WHERE aav.person_id = acaiv.person_id AND

Line 114: cp_alt_appl_id IGS_AD_APPL.alt_appl_id%TYPE) IS

110: cp_us_version_number IGS_AD_PS_APPL_INST.us_version_number%TYPE,
111: cp_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE,
112: cp_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE,
113: cp_choice_number IGS_AD_APPL.choice_number%TYPE,
114: cp_alt_appl_id IGS_AD_APPL.alt_appl_id%TYPE) IS
115: SELECT 'x'
116: FROM IGS_AD_APPL aav, IGS_AD_PS_APPL_INST acaiv
117: WHERE aav.person_id = acaiv.person_id AND
118: aav.admission_appl_number = acaiv.admission_appl_number AND

Line 116: FROM IGS_AD_APPL aav, IGS_AD_PS_APPL_INST acaiv

112: cp_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE,
113: cp_choice_number IGS_AD_APPL.choice_number%TYPE,
114: cp_alt_appl_id IGS_AD_APPL.alt_appl_id%TYPE) IS
115: SELECT 'x'
116: FROM IGS_AD_APPL aav, IGS_AD_PS_APPL_INST acaiv
117: WHERE aav.person_id = acaiv.person_id AND
118: aav.admission_appl_number = acaiv.admission_appl_number AND
119: acaiv.person_id = cp_person_id AND
120: acaiv.course_cd = cp_course_cd AND

Line 136: CURSOR c_aav_uk(cp_person_id igs_ad_appl.person_id%TYPE, cp_admission_appl_number igs_ad_appl.admission_appl_number%TYPE) IS

132: NVL(aav.alt_appl_id, 0) = NVL(cp_alt_appl_id,0) AND
133: -- Check for CANCELLED added for bug 2678766
134: NVL(IGS_AD_GEN_008.ADMP_GET_SAOS(acaiv.adm_outcome_status),'x') <> 'CANCELLED';
135:
136: CURSOR c_aav_uk(cp_person_id igs_ad_appl.person_id%TYPE, cp_admission_appl_number igs_ad_appl.admission_appl_number%TYPE) IS
137: SELECT
138: choice_number, alt_appl_id
139: FROM
140: igs_ad_appl aav

Line 140: igs_ad_appl aav

136: CURSOR c_aav_uk(cp_person_id igs_ad_appl.person_id%TYPE, cp_admission_appl_number igs_ad_appl.admission_appl_number%TYPE) IS
137: SELECT
138: choice_number, alt_appl_id
139: FROM
140: igs_ad_appl aav
141: WHERE
142: aav.person_id = cp_person_id
143: AND aav.admission_appl_number = cp_admission_appl_number;
144:

Line 172: cp_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE,

168: cp_attendance_mode IGS_AD_PS_APPL_INST.attendance_mode%TYPE,
169: cp_attendance_type IGS_AD_PS_APPL_INST.attendance_type%TYPE,
170: cp_unit_set_cd IGS_AD_PS_APPL_INST.unit_set_cd%TYPE,
171: cp_us_version_number IGS_AD_PS_APPL_INST.us_version_number%TYPE,
172: cp_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE,
173: cp_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE) IS
174: SELECT aa.adm_appl_status
175: FROM IGS_AD_PS_APPL_INST acaiv,
176: IGS_AD_APPL aa

Line 173: cp_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE) IS

169: cp_attendance_type IGS_AD_PS_APPL_INST.attendance_type%TYPE,
170: cp_unit_set_cd IGS_AD_PS_APPL_INST.unit_set_cd%TYPE,
171: cp_us_version_number IGS_AD_PS_APPL_INST.us_version_number%TYPE,
172: cp_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE,
173: cp_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE) IS
174: SELECT aa.adm_appl_status
175: FROM IGS_AD_PS_APPL_INST acaiv,
176: IGS_AD_APPL aa
177: WHERE acaiv.person_id = cp_person_id AND

Line 176: IGS_AD_APPL aa

172: cp_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE,
173: cp_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE) IS
174: SELECT aa.adm_appl_status
175: FROM IGS_AD_PS_APPL_INST acaiv,
176: IGS_AD_APPL aa
177: WHERE acaiv.person_id = cp_person_id AND
178: acaiv.nominated_course_cd = cp_course_cd AND
179: (acaiv.admission_appl_number <> cp_admission_appl_number OR
180: acaiv.sequence_number <> cp_acai_sequence_number) AND

Line 196: FROM IGS_AD_APPL_LTR aal

192: cp_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,
193: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE)
194: IS
195: SELECT 'x'
196: FROM IGS_AD_APPL_LTR aal
197: WHERE aal.person_id = cp_person_id AND
198: aal.admission_appl_number = cp_admission_appl_number;
199: CURSOR c_aa (
200: cp_person_id IGS_AD_APPL.person_id%TYPE,

Line 200: cp_person_id IGS_AD_APPL.person_id%TYPE,

196: FROM IGS_AD_APPL_LTR aal
197: WHERE aal.person_id = cp_person_id AND
198: aal.admission_appl_number = cp_admission_appl_number;
199: CURSOR c_aa (
200: cp_person_id IGS_AD_APPL.person_id%TYPE,
201: cp_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE) IS
202: SELECT aas.s_adm_appl_status
203: FROM IGS_AD_APPL aa,
204: IGS_AD_APPL_STAT aas

Line 201: cp_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE) IS

197: WHERE aal.person_id = cp_person_id AND
198: aal.admission_appl_number = cp_admission_appl_number;
199: CURSOR c_aa (
200: cp_person_id IGS_AD_APPL.person_id%TYPE,
201: cp_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE) IS
202: SELECT aas.s_adm_appl_status
203: FROM IGS_AD_APPL aa,
204: IGS_AD_APPL_STAT aas
205: WHERE aa.person_id = cp_person_id AND

Line 203: FROM IGS_AD_APPL aa,

199: CURSOR c_aa (
200: cp_person_id IGS_AD_APPL.person_id%TYPE,
201: cp_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE) IS
202: SELECT aas.s_adm_appl_status
203: FROM IGS_AD_APPL aa,
204: IGS_AD_APPL_STAT aas
205: WHERE aa.person_id = cp_person_id AND
206: aa.admission_appl_number = cp_admission_appl_number AND
207: aas.adm_appl_status = aa.adm_appl_status;

Line 204: IGS_AD_APPL_STAT aas

200: cp_person_id IGS_AD_APPL.person_id%TYPE,
201: cp_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE) IS
202: SELECT aas.s_adm_appl_status
203: FROM IGS_AD_APPL aa,
204: IGS_AD_APPL_STAT aas
205: WHERE aa.person_id = cp_person_id AND
206: aa.admission_appl_number = cp_admission_appl_number AND
207: aas.adm_appl_status = aa.adm_appl_status;
208: BEGIN

Line 363: v_s_appl_inst_status IGS_AD_APPL_STAT.s_adm_appl_status%TYPE;

359: RETURN BOOLEAN AS
360: BEGIN --admp_val_acai_update
361: --This module validates update of an IGS_AD_PS_APPL_INST record.
362: DECLARE
363: v_s_appl_inst_status IGS_AD_APPL_STAT.s_adm_appl_status%TYPE;
364: v_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE;
365: cst_withdrawn CONSTANT VARCHAR2(10) := 'WITHDRAWN';
366: CURSOR c_sca (
367: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

Line 408: p_message_name := 'IGS_AD_APPL_INST_WITHD';

404: v_s_appl_inst_status), 'NULL');
405: END IF;
406:
407: IF v_s_appl_inst_status = cst_withdrawn THEN
408: p_message_name := 'IGS_AD_APPL_INST_WITHD';
409: p_update_non_enrol_detail_ind := 'N';
410: RETURN FALSE;
411: ELSIF igs_ad_gen_002.Is_App_Inst_Complete(p_person_id, p_admission_appl_number, p_nominated_course_cd, p_acai_sequence_number) = 'Y' THEN
412: p_message_name := 'IGS_AD_APPL_INST_COMPL';

Line 412: p_message_name := 'IGS_AD_APPL_INST_COMPL';

408: p_message_name := 'IGS_AD_APPL_INST_WITHD';
409: p_update_non_enrol_detail_ind := 'N';
410: RETURN FALSE;
411: ELSIF igs_ad_gen_002.Is_App_Inst_Complete(p_person_id, p_admission_appl_number, p_nominated_course_cd, p_acai_sequence_number) = 'Y' THEN
412: p_message_name := 'IGS_AD_APPL_INST_COMPL';
413: p_update_non_enrol_detail_ind := 'N';
414: RETURN FALSE;
415: END IF; --arvsrini igsm
416:

Line 463: FROM IGS_AD_APPL_LTR

459: -- Validate delete of an IGS_AD_PS_APPL_INST record
460: DECLARE
461: CURSOR c_aal IS
462: SELECT 'x'
463: FROM IGS_AD_APPL_LTR
464: WHERE person_id = p_person_id AND
465: admission_appl_number = p_admission_appl_number;
466: CURSOR c_aas IS
467: SELECT 'x'

Line 468: FROM IGS_AD_APPL aa,

464: WHERE person_id = p_person_id AND
465: admission_appl_number = p_admission_appl_number;
466: CURSOR c_aas IS
467: SELECT 'x'
468: FROM IGS_AD_APPL aa,
469: IGS_AD_APPL_STAT aas
470: WHERE aa.person_id = p_person_id AND
471: aa.admission_appl_number = p_admission_appl_number AND
472: aas.adm_appl_status = aa.adm_appl_status AND

Line 469: IGS_AD_APPL_STAT aas

465: admission_appl_number = p_admission_appl_number;
466: CURSOR c_aas IS
467: SELECT 'x'
468: FROM IGS_AD_APPL aa,
469: IGS_AD_APPL_STAT aas
470: WHERE aa.person_id = p_person_id AND
471: aa.admission_appl_number = p_admission_appl_number AND
472: aas.adm_appl_status = aa.adm_appl_status AND
473: aas.s_adm_appl_status = 'WITHDRAWN';

Line 872: p_message_name := 'IGS_AD_APPL_NOT_EXISTING_STUD';

868: IF (c_sca%NOTFOUND) THEN
869: CLOSE c_sca;
870: IF p_s_admission_process_type = 'RE-ADMIT' THEN
871: p_return_type := cst_error;
872: p_message_name := 'IGS_AD_APPL_NOT_EXISTING_STUD';
873: RETURN FALSE;
874: END IF;
875: RETURN TRUE;
876: END IF;

Line 883: p_message_name := 'IGS_AD_APPL_EXISTING_STUDPRG';

879: IF p_s_admission_process_type <> 'RE-ADMIT' THEN
880: -- Validate against all other system admission process types
881: IF v_sca_rec.course_attempt_status NOT IN ('DELETED', 'UNCONFIRM') THEN
882: p_return_type := cst_error;
883: p_message_name := 'IGS_AD_APPL_EXISTING_STUDPRG';
884: RETURN FALSE;
885: END IF;
886: RETURN TRUE;
887: END IF;

Line 889: p_message_name := 'IGS_AD_APPL_CANNOT_READMITTED';

885: END IF;
886: RETURN TRUE;
887: END IF;
888: IF (v_sca_rec.course_attempt_status <> 'DISCONTIN') THEN
889: p_message_name := 'IGS_AD_APPL_CANNOT_READMITTED';
890: p_return_type := cst_error;
891: RETURN FALSE;
892: END IF;
893: -- Validate against any existing student course transfer details

Line 976: p_message_name := 'IGS_AD_APPL_ENROLLED_12MONTHS';

972: -- Validate the discontinued date
973: IF p_appl_dt IS NOT NULL AND
974: v_sca_rec.discontinued_dt IS NOT NULL AND
975: MONTHS_BETWEEN(p_appl_dt, v_sca_rec.discontinued_dt) <= 12 THEN
976: p_message_name := 'IGS_AD_APPL_ENROLLED_12MONTHS';
977: p_return_type := cst_warn;
978: RETURN FALSE;
979: END IF;
980: END IF;

Line 1164: cp_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE,

1160: delete_flag= 'N';
1161: CURSOR c_cop (
1162: cp_course_cd IGS_AD_PS_APPL_INST.course_cd%TYPE,
1163: cp_version_number IGS_AD_PS_APPL_INST.crv_version_number%TYPE,
1164: cp_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE,
1165: cp_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE,
1166: cp_location_cd IGS_AD_PS_APPL_INST.location_cd%TYPE,
1167: cp_attendance_mode IGS_AD_PS_APPL_INST.attendance_mode%TYPE,
1168: cp_attendance_type IGS_AD_PS_APPL_INST.attendance_type%TYPE) IS

Line 1165: cp_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE,

1161: CURSOR c_cop (
1162: cp_course_cd IGS_AD_PS_APPL_INST.course_cd%TYPE,
1163: cp_version_number IGS_AD_PS_APPL_INST.crv_version_number%TYPE,
1164: cp_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE,
1165: cp_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE,
1166: cp_location_cd IGS_AD_PS_APPL_INST.location_cd%TYPE,
1167: cp_attendance_mode IGS_AD_PS_APPL_INST.attendance_mode%TYPE,
1168: cp_attendance_type IGS_AD_PS_APPL_INST.attendance_type%TYPE) IS
1169: SELECT 'x'

Line 1338: p_message_name := 'IGS_AD_APPL_CLOSINGDT_PASSED';

1334: IF v_ac_match THEN
1335: IF v_ap_match THEN
1336: -- There must have been no Application Date Match
1337: IF p_offer_ind = 'Y' THEN
1338: p_message_name := 'IGS_AD_APPL_CLOSINGDT_PASSED';
1339: p_return_type := cst_error;
1340: ELSE
1341: IF p_deferred_appl = 'N' THEN
1342: IF p_attendance_type IS NULL OR P_attendance_mode IS NULL THEN

Line 1343: p_message_name := 'IGS_AD_APPL_CLOSINGDT_PASSED';

1339: p_return_type := cst_error;
1340: ELSE
1341: IF p_deferred_appl = 'N' THEN
1342: IF p_attendance_type IS NULL OR P_attendance_mode IS NULL THEN
1343: p_message_name := 'IGS_AD_APPL_CLOSINGDT_PASSED';
1344: p_return_type := cst_error;
1345: ELSE
1346: p_message_name := 'IGS_AD_APPLDT_HAS_PASSED';
1347: p_return_type := cst_warn;

Line 1346: p_message_name := 'IGS_AD_APPLDT_HAS_PASSED';

1342: IF p_attendance_type IS NULL OR P_attendance_mode IS NULL THEN
1343: p_message_name := 'IGS_AD_APPL_CLOSINGDT_PASSED';
1344: p_return_type := cst_error;
1345: ELSE
1346: p_message_name := 'IGS_AD_APPLDT_HAS_PASSED';
1347: p_return_type := cst_warn;
1348: END IF;
1349: ELSE
1350: p_message_name := 'IGS_AD_POO_PRG_OFRING_LATEFEE';

Line 1470: p_message_name := 'IGS_AD_APPLDT_ADMAPPL_DUEDT';

1466: IF p_appl_dt > v_due_dt THEN
1467: -- Admission course application instance is invalid
1468: -- because the application date is after the due date
1469: -- of the course offering option.
1470: p_message_name := 'IGS_AD_APPLDT_ADMAPPL_DUEDT';
1471: RETURN FALSE;
1472: END IF;
1473: END IF;
1474: END IF;

Line 2328: p_message_name := 'IGS_AD_APPL_RESP_COMMENTS';

2324: -- applicant has responded to an offer of admission.
2325: IF v_s_adm_offer_resp_status IN (cst_pending,
2326: cst_lapsed,
2327: cst_not_applic) THEN
2328: p_message_name := 'IGS_AD_APPL_RESP_COMMENTS';
2329: RETURN FALSE;
2330: END IF;
2331: END IF;
2332: RETURN TRUE;

Line 3535: FROM IGS_AD_APPL /* Replaced IGS_AD_APPL_ADMAPPL_V with IGS_AD_APPL Bug 3150054 */

3531: CURSOR c_apcs IS
3532: SELECT apcs.s_admission_step_type
3533: FROM IGS_AD_PRCS_CAT_STEP apcs
3534: WHERE admission_cat= (SELECT admission_cat
3535: FROM IGS_AD_APPL /* Replaced IGS_AD_APPL_ADMAPPL_V with IGS_AD_APPL Bug 3150054 */
3536: WHERE person_id = p_person_id AND
3537: admission_appl_number=p_admission_appl_number) AND
3538: s_admission_process_type = p_s_admission_process_type AND
3539: mandatory_step_ind = 'Y' AND

Line 3544: FROM IGS_ad_appl_eval_v

3540: step_group_type <> 'TRACK';
3541:
3542: CURSOR c_ae IS
3543: SELECT person_id
3544: FROM IGS_ad_appl_eval_v
3545: WHERE person_id = p_person_id AND
3546: admission_appl_number = p_admission_appl_number AND
3547: nominated_course_cd = p_nominated_course_cd;
3548: CURSOR c_pa IS

Line 3550: FROM igs_Ad_appl_pgmapprv_v

3546: admission_appl_number = p_admission_appl_number AND
3547: nominated_course_cd = p_nominated_course_cd;
3548: CURSOR c_pa IS
3549: SELECT person_id
3550: FROM igs_Ad_appl_pgmapprv_v
3551: WHERE person_id = p_person_id AND
3552: admission_appl_number = p_admission_appl_number AND
3553: nominated_course_cd = p_nominated_course_cd;
3554: CURSOR c_us IS