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.

[Home] [Help]

APPS.IGS_FI_PRC_FEE_ASS dependencies on IGS_EN_UNIT_SET_CAT

Line 553: cp_v_s_unit_set_cat igs_en_unit_set_cat.s_unit_set_cat%TYPE) IS

549: CURSOR cur_unit_set (cp_person_id hz_parties.party_id%TYPE,
550: cp_course_cd igs_ps_ver_all.course_cd%TYPE,
551: cp_effective_dt DATE,
552: cp_v_student_confirmed_ind igs_as_su_setatmpt.student_confirmed_ind%TYPE,
553: cp_v_s_unit_set_cat igs_en_unit_set_cat.s_unit_set_cat%TYPE) IS
554: SELECT asu.unit_set_cd,
555: asu.us_version_number
556: FROM igs_as_su_setatmpt asu,
557: igs_en_unit_set_all us,

Line 558: igs_en_unit_set_cat usc

554: SELECT asu.unit_set_cd,
555: asu.us_version_number
556: FROM igs_as_su_setatmpt asu,
557: igs_en_unit_set_all us,
558: igs_en_unit_set_cat usc
559: WHERE asu.person_id = cp_person_id
560: AND asu.course_cd = cp_course_cd
561: AND asu.student_confirmed_ind = cp_v_student_confirmed_ind
562: AND TRUNC(cp_effective_dt) BETWEEN TRUNC(asu.selection_dt) AND NVL(TRUNC(asu.rqrmnts_complete_dt), NVL(TRUNC(asu.end_dt), TRUNC(cp_effective_dt)))

Line 6952: cp_v_s_unit_set_cat igs_en_unit_set_cat.s_unit_set_cat%TYPE) IS

6948: CURSOR cur_unit_set (cp_person_id hz_parties.party_id%TYPE,
6949: cp_course_cd igs_ps_ver_all.course_cd%TYPE,
6950: cp_effective_dt DATE,
6951: cp_v_student_confirmed_ind igs_as_su_setatmpt.student_confirmed_ind%TYPE,
6952: cp_v_s_unit_set_cat igs_en_unit_set_cat.s_unit_set_cat%TYPE) IS
6953: SELECT asu.unit_set_cd,
6954: asu.us_version_number
6955: FROM igs_as_su_setatmpt asu,
6956: igs_en_unit_set_all us,

Line 6957: igs_en_unit_set_cat usc

6953: SELECT asu.unit_set_cd,
6954: asu.us_version_number
6955: FROM igs_as_su_setatmpt asu,
6956: igs_en_unit_set_all us,
6957: igs_en_unit_set_cat usc
6958: WHERE asu.person_id = cp_person_id
6959: AND asu.course_cd = cp_course_cd
6960: AND asu.student_confirmed_ind = cp_v_student_confirmed_ind
6961: AND TRUNC(cp_effective_dt) BETWEEN TRUNC(asu.selection_dt) AND NVL(TRUNC(asu.rqrmnts_complete_dt), NVL(TRUNC(asu.end_dt), TRUNC(cp_effective_dt)))