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_FI_PRC_FEE_ASS dependencies on IGS_EN_STDNT_PS_INTM

Line 9386: CURSOR c_latest_intermit_date ( cp_n_person_id igs_en_stdnt_ps_intm.person_id%TYPE,

9382: l_d_crs_cmpl_dt DATE;
9383: l_v_message_name fnd_new_messages.message_name%TYPE;
9384:
9385: -- Cursor to get latest intermission end date.
9386: CURSOR c_latest_intermit_date ( cp_n_person_id igs_en_stdnt_ps_intm.person_id%TYPE,
9387: cp_v_course_cd igs_ps_ver_all.course_cd%TYPE,
9388: cp_logical_delete_date igs_en_stdnt_ps_intm.logical_delete_date%TYPE) IS
9389: SELECT sci.end_dt
9390: FROM igs_en_stdnt_ps_intm sci,

Line 9388: cp_logical_delete_date igs_en_stdnt_ps_intm.logical_delete_date%TYPE) IS

9384:
9385: -- Cursor to get latest intermission end date.
9386: CURSOR c_latest_intermit_date ( cp_n_person_id igs_en_stdnt_ps_intm.person_id%TYPE,
9387: cp_v_course_cd igs_ps_ver_all.course_cd%TYPE,
9388: cp_logical_delete_date igs_en_stdnt_ps_intm.logical_delete_date%TYPE) IS
9389: SELECT sci.end_dt
9390: FROM igs_en_stdnt_ps_intm sci,
9391: IGS_EN_INTM_TYPES eit
9392: WHERE sci.person_id = cp_n_person_id

Line 9390: FROM igs_en_stdnt_ps_intm sci,

9386: CURSOR c_latest_intermit_date ( cp_n_person_id igs_en_stdnt_ps_intm.person_id%TYPE,
9387: cp_v_course_cd igs_ps_ver_all.course_cd%TYPE,
9388: cp_logical_delete_date igs_en_stdnt_ps_intm.logical_delete_date%TYPE) IS
9389: SELECT sci.end_dt
9390: FROM igs_en_stdnt_ps_intm sci,
9391: IGS_EN_INTM_TYPES eit
9392: WHERE sci.person_id = cp_n_person_id
9393: AND sci.course_cd = cp_v_course_cd
9394: AND sci.logical_delete_date = cp_logical_delete_date

Line 9398: l_d_int_end_dt igs_en_stdnt_ps_intm.end_dt%TYPE;

9394: AND sci.logical_delete_date = cp_logical_delete_date
9395: AND sci.approved = eit.appr_reqd_ind AND
9396: eit.intermission_type = sci.intermission_type
9397: ORDER BY end_dt DESC;
9398: l_d_int_end_dt igs_en_stdnt_ps_intm.end_dt%TYPE;
9399:
9400: -- Cursor to get the admission offer response status and admission calendar instance details
9401: CURSOR c_adm_details ( cp_n_person_id igs_en_stdnt_ps_intm.person_id%TYPE,
9402: cp_n_adm_admission_appl_number igs_en_stdnt_ps_att_all.adm_admission_appl_number%TYPE,

Line 9401: CURSOR c_adm_details ( cp_n_person_id igs_en_stdnt_ps_intm.person_id%TYPE,

9397: ORDER BY end_dt DESC;
9398: l_d_int_end_dt igs_en_stdnt_ps_intm.end_dt%TYPE;
9399:
9400: -- Cursor to get the admission offer response status and admission calendar instance details
9401: CURSOR c_adm_details ( cp_n_person_id igs_en_stdnt_ps_intm.person_id%TYPE,
9402: cp_n_adm_admission_appl_number igs_en_stdnt_ps_att_all.adm_admission_appl_number%TYPE,
9403: cp_v_adm_nominated_course_cd igs_en_stdnt_ps_att_all.adm_nominated_course_cd%TYPE,
9404: cp_n_adm_sequence_number igs_en_stdnt_ps_att_all.adm_sequence_number%TYPE ) IS
9405: SELECT off.s_adm_offer_resp_status,