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_ALL

Line 557: igs_en_unit_set_all us,

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,
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

Line 568: l_v_unit_set_cd igs_en_unit_set_all.unit_set_cd%TYPE;

564: AND asu.us_version_number = us.version_number
565: AND us.unit_set_cat = usc.unit_set_cat
566: AND usc.s_unit_set_cat = cp_v_s_unit_set_cat;
567:
568: l_v_unit_set_cd igs_en_unit_set_all.unit_set_cd%TYPE;
569: l_n_us_version_number igs_en_unit_set_all.version_number%TYPE;
570:
571: BEGIN
572:

Line 569: l_n_us_version_number igs_en_unit_set_all.version_number%TYPE;

565: AND us.unit_set_cat = usc.unit_set_cat
566: AND usc.s_unit_set_cat = cp_v_s_unit_set_cat;
567:
568: l_v_unit_set_cd igs_en_unit_set_all.unit_set_cd%TYPE;
569: l_n_us_version_number igs_en_unit_set_all.version_number%TYPE;
570:
571: BEGIN
572:
573: p_v_unit_set_cd := NULL;

Line 1923: p_derived_unit_set_cd OUT NOCOPY igs_en_unit_set_all.unit_set_cd%TYPE,

1919: p_derived_prog_att_mode OUT NOCOPY igs_en_atd_mode_all.attendance_mode%TYPE, -- Added as part of 3795849
1920: p_derived_residency_status_cd OUT NOCOPY igs_pe_res_dtls_all.residency_status_cd%TYPE,
1921: p_derived_class_standing OUT NOCOPY IGS_PR_CLASS_STD.CLASS_STANDING%TYPE,
1922: p_c_career IN igs_ps_ver_all.course_type%TYPE,
1923: p_derived_unit_set_cd OUT NOCOPY igs_en_unit_set_all.unit_set_cd%TYPE,
1924: p_derived_us_version_num OUT NOCOPY igs_en_unit_set_all.version_number%TYPE
1925: ) RETURN BOOLEAN AS
1926: /*************************************************************
1927: Created By :

Line 1924: p_derived_us_version_num OUT NOCOPY igs_en_unit_set_all.version_number%TYPE

1920: p_derived_residency_status_cd OUT NOCOPY igs_pe_res_dtls_all.residency_status_cd%TYPE,
1921: p_derived_class_standing OUT NOCOPY IGS_PR_CLASS_STD.CLASS_STANDING%TYPE,
1922: p_c_career IN igs_ps_ver_all.course_type%TYPE,
1923: p_derived_unit_set_cd OUT NOCOPY igs_en_unit_set_all.unit_set_cd%TYPE,
1924: p_derived_us_version_num OUT NOCOPY igs_en_unit_set_all.version_number%TYPE
1925: ) RETURN BOOLEAN AS
1926: /*************************************************************
1927: Created By :
1928: Date Created By :

Line 6956: igs_en_unit_set_all us,

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,
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