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_LOOKUPS_VIEW

Line 1120: CURSOR c_sca_psv ( cp_v_lookup_type igs_lookups_view.lookup_type%TYPE,

1116: c_att_md_ty l_der_nom_ref;
1117: l_c_att_md_ty c_att_md_ty%ROWTYPE;
1118: l_n_cr_points igs_en_su_attempt_all.override_achievable_cp%TYPE;
1119: l_n_fte igs_en_su_attempt_all.override_achievable_cp%TYPE;
1120: CURSOR c_sca_psv ( cp_v_lookup_type igs_lookups_view.lookup_type%TYPE,
1121: cp_v_fee_ass_ind igs_lookups_view.fee_ass_ind%TYPE ) IS
1122: SELECT spat.person_id,
1123: spat.program_cd,
1124: spat.program_version,

Line 1121: cp_v_fee_ass_ind igs_lookups_view.fee_ass_ind%TYPE ) IS

1117: l_c_att_md_ty c_att_md_ty%ROWTYPE;
1118: l_n_cr_points igs_en_su_attempt_all.override_achievable_cp%TYPE;
1119: l_n_fte igs_en_su_attempt_all.override_achievable_cp%TYPE;
1120: CURSOR c_sca_psv ( cp_v_lookup_type igs_lookups_view.lookup_type%TYPE,
1121: cp_v_fee_ass_ind igs_lookups_view.fee_ass_ind%TYPE ) IS
1122: SELECT spat.person_id,
1123: spat.program_cd,
1124: spat.program_version,
1125: spat.fee_cat,

Line 1139: igs_lookups_view lkps

1135: ps.course_type
1136: FROM igs_en_spa_terms spat,
1137: igs_en_stdnt_ps_att_all sca,
1138: igs_ps_ver_all ps,
1139: igs_lookups_view lkps
1140: WHERE spat.person_id = p_person_id
1141: AND spat.person_id = sca.person_id
1142: AND spat.program_cd = sca.course_cd
1143: AND spat.program_version = sca.version_number

Line 4672: cp_v_lookup_type igs_lookups_view.lookup_type%TYPE,

4668: cp_v_program_cd VARCHAR2,
4669: cp_v_fee_cat VARCHAR2,
4670: cp_v_course_type VARCHAR2,
4671: cp_v_key_program_flag igs_en_spa_terms.key_program_flag%TYPE,
4672: cp_v_lookup_type igs_lookups_view.lookup_type%TYPE,
4673: cp_v_fee_ass_ind igs_lookups_view.fee_ass_ind%TYPE) IS
4674: SELECT esptv.person_id,
4675: esptv.program_cd,
4676: esptv.program_version,

Line 4673: cp_v_fee_ass_ind igs_lookups_view.fee_ass_ind%TYPE) IS

4669: cp_v_fee_cat VARCHAR2,
4670: cp_v_course_type VARCHAR2,
4671: cp_v_key_program_flag igs_en_spa_terms.key_program_flag%TYPE,
4672: cp_v_lookup_type igs_lookups_view.lookup_type%TYPE,
4673: cp_v_fee_ass_ind igs_lookups_view.fee_ass_ind%TYPE) IS
4674: SELECT esptv.person_id,
4675: esptv.program_cd,
4676: esptv.program_version,
4677: psv.course_type,

Line 4691: igs_lookups_view scas

4687: esptv.key_program_flag
4688: FROM igs_en_spa_terms esptv,
4689: igs_ps_ver_all psv,
4690: igs_en_stdnt_ps_att_all sca,
4691: igs_lookups_view scas
4692: WHERE esptv.program_cd = psv.course_cd
4693: AND esptv.program_version = psv.version_number
4694: AND esptv.program_cd = sca.course_cd
4695: AND esptv.program_version = sca.version_number

Line 4726: cp_v_lookup_type igs_lookups_view.lookup_type%TYPE,

4722: cp_v_load_cal_type igs_ca_inst_all.cal_type%TYPE,
4723: cp_n_load_ci_seq_num igs_ca_inst_all.sequence_number%TYPE,
4724: cp_v_key_program_flag igs_en_spa_terms.key_program_flag%TYPE,
4725: cp_v_course_type igs_ps_ver_all.course_type%TYPE,
4726: cp_v_lookup_type igs_lookups_view.lookup_type%TYPE,
4727: cp_v_fee_ass_ind igs_lookups_view.fee_ass_ind%TYPE,
4728: cp_v_fee_cat igs_en_spa_terms.fee_cat%TYPE) IS
4729: SELECT esptv.person_id,
4730: esptv.program_cd,

Line 4727: cp_v_fee_ass_ind igs_lookups_view.fee_ass_ind%TYPE,

4723: cp_n_load_ci_seq_num igs_ca_inst_all.sequence_number%TYPE,
4724: cp_v_key_program_flag igs_en_spa_terms.key_program_flag%TYPE,
4725: cp_v_course_type igs_ps_ver_all.course_type%TYPE,
4726: cp_v_lookup_type igs_lookups_view.lookup_type%TYPE,
4727: cp_v_fee_ass_ind igs_lookups_view.fee_ass_ind%TYPE,
4728: cp_v_fee_cat igs_en_spa_terms.fee_cat%TYPE) IS
4729: SELECT esptv.person_id,
4730: esptv.program_cd,
4731: esptv.program_version,

Line 4746: igs_lookups_view scas

4742: esptv.key_program_flag
4743: FROM igs_en_spa_terms esptv,
4744: igs_ps_ver_all psv,
4745: igs_en_stdnt_ps_att_all sca,
4746: igs_lookups_view scas
4747: WHERE esptv.program_cd = psv.course_cd
4748: AND esptv.program_version = psv.version_number
4749: AND esptv.program_cd = sca.course_cd
4750: AND esptv.program_version = sca.version_number

Line 5049: cp_v_lookup_type igs_lookups_view.lookup_type%TYPE,

5045:
5046: CURSOR cur_dropped_unit (cp_person_id hz_parties.party_id%TYPE,
5047: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,
5048: cp_v_fee_ass_ind VARCHAR2,
5049: cp_v_lookup_type igs_lookups_view.lookup_type%TYPE,
5050: cp_v_enrp_get_load_apply VARCHAR2,
5051: cp_n_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS
5052: SELECT discontinued_dt
5053: FROM igs_en_su_attempt_all sua,

Line 5054: igs_lookups_view lkp

5050: cp_v_enrp_get_load_apply VARCHAR2,
5051: cp_n_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS
5052: SELECT discontinued_dt
5053: FROM igs_en_su_attempt_all sua,
5054: igs_lookups_view lkp
5055: WHERE lkp.lookup_code = sua.unit_attempt_status
5056: AND lkp.lookup_type = cp_v_lookup_type
5057: AND (sua.no_assessment_ind = cp_v_fee_ass_ind OR cp_v_fee_ass_ind IS NULL)
5058: AND sua.person_id = cp_person_id

Line 6769: cp_v_lookup_type igs_lookups_view.lookup_type%TYPE,

6765: -- Enh# 3167098, modified following cursor
6766: CURSOR c_sualv_scafv (cp_person_id hz_parties.party_id%TYPE,
6767: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,
6768: cp_v_fee_ass_ind VARCHAR2,
6769: cp_v_lookup_type igs_lookups_view.lookup_type%TYPE,
6770: cp_v_fee_ass_indicator igs_lookups_view.fee_ass_ind%TYPE) IS
6771: SELECT sua.cal_type,
6772: sua.ci_sequence_number,
6773: sua.discontinued_dt,

Line 6770: cp_v_fee_ass_indicator igs_lookups_view.fee_ass_ind%TYPE) IS

6766: CURSOR c_sualv_scafv (cp_person_id hz_parties.party_id%TYPE,
6767: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,
6768: cp_v_fee_ass_ind VARCHAR2,
6769: cp_v_lookup_type igs_lookups_view.lookup_type%TYPE,
6770: cp_v_fee_ass_indicator igs_lookups_view.fee_ass_ind%TYPE) IS
6771: SELECT sua.cal_type,
6772: sua.ci_sequence_number,
6773: sua.discontinued_dt,
6774: sua.administrative_unit_status,

Line 6786: igs_lookups_view lkp,

6782: sua.location_cd,
6783: sua.org_unit_cd,
6784: uoo.owner_org_unit_cd
6785: FROM igs_en_su_attempt_all sua,
6786: igs_lookups_view lkp,
6787: igs_ps_unit_ofr_opt_all uoo
6788: WHERE lkp.lookup_code = sua.unit_attempt_status
6789: AND lkp.lookup_type = cp_v_lookup_type
6790: AND lkp.fee_ass_ind = cp_v_fee_ass_indicator

Line 6805: cp_v_fee_ass_indicator igs_lookups_view.fee_ass_ind%TYPE,

6801: cp_load_cal_type igs_ca_inst_all.cal_type%TYPE,
6802: cp_load_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,
6803: cp_v_fee_ass_ind VARCHAR2,
6804: cp_v_lookup_type igs_lookup_values.lookup_type%TYPE,
6805: cp_v_fee_ass_indicator igs_lookups_view.fee_ass_ind%TYPE,
6806: cp_v_enrp_get_load_apply VARCHAR2
6807: ) IS
6808: SELECT sua.course_cd,
6809: sua.unit_cd,

Line 6849: igs_lookups_view suas,

6845: sua.no_assessment_ind,
6846: sua.org_unit_cd,
6847: uoo.owner_org_unit_cd
6848: FROM igs_en_su_attempt_all sua,
6849: igs_lookups_view suas,
6850: igs_en_spa_terms terms,
6851: igs_ps_unit_ofr_opt_all uoo
6852: WHERE sua.person_id = p_person_id AND
6853: sua.person_id = terms.person_id AND

Line 6891: CURSOR c_sca_psv ( cp_v_lookup_type igs_lookups_view.lookup_type%TYPE,

6887: AND v.version_number = cp_version_number;
6888:
6889: -- Enh# 3167098, Removed references to igs_fi_f_cat_cal_rel and igs_fi_cng_fcat_lbl_sca_pr_v in following cursor.
6890: -- For CAREER, Term records are created only for primary programs. So, select all programs from terms table.
6891: CURSOR c_sca_psv ( cp_v_lookup_type igs_lookups_view.lookup_type%TYPE,
6892: cp_v_fee_ass_ind igs_lookups_view.fee_ass_ind%TYPE ) IS
6893: SELECT spat.person_id,
6894: spat.program_cd,
6895: spat.program_version,

Line 6892: cp_v_fee_ass_ind igs_lookups_view.fee_ass_ind%TYPE ) IS

6888:
6889: -- Enh# 3167098, Removed references to igs_fi_f_cat_cal_rel and igs_fi_cng_fcat_lbl_sca_pr_v in following cursor.
6890: -- For CAREER, Term records are created only for primary programs. So, select all programs from terms table.
6891: CURSOR c_sca_psv ( cp_v_lookup_type igs_lookups_view.lookup_type%TYPE,
6892: cp_v_fee_ass_ind igs_lookups_view.fee_ass_ind%TYPE ) IS
6893: SELECT spat.person_id,
6894: spat.program_cd,
6895: spat.program_version,
6896: spat.fee_cat,

Line 6910: igs_lookups_view lkps

6906: ps.course_type
6907: FROM igs_en_spa_terms spat,
6908: igs_en_stdnt_ps_att_all sca,
6909: igs_ps_ver_all ps,
6910: igs_lookups_view lkps
6911: WHERE spat.person_id = p_person_id
6912: AND spat.person_id = sca.person_id
6913: AND spat.program_cd = sca.course_cd
6914: AND spat.program_version = sca.version_number

Line 7955: CURSOR c_std_term_spas( cp_v_lookup_type igs_lookups_view.lookup_type%TYPE,

7951: AND fee_type = ast.fee_type);
7952:
7953: -- Actual Mode of processing, when the fee calculation method is 'Program','Career'.
7954: -- Get all the program attempts from the student terms table, other than the program/career that is in context
7955: CURSOR c_std_term_spas( cp_v_lookup_type igs_lookups_view.lookup_type%TYPE,
7956: cp_v_fee_ass_ind igs_lookups_view.fee_ass_ind%TYPE ) IS
7957: SELECT spt.program_cd,
7958: spt.program_version,
7959: spt.fee_cat,

Line 7956: cp_v_fee_ass_ind igs_lookups_view.fee_ass_ind%TYPE ) IS

7952:
7953: -- Actual Mode of processing, when the fee calculation method is 'Program','Career'.
7954: -- Get all the program attempts from the student terms table, other than the program/career that is in context
7955: CURSOR c_std_term_spas( cp_v_lookup_type igs_lookups_view.lookup_type%TYPE,
7956: cp_v_fee_ass_ind igs_lookups_view.fee_ass_ind%TYPE ) IS
7957: SELECT spt.program_cd,
7958: spt.program_version,
7959: spt.fee_cat,
7960: spa.adm_admission_appl_number,

Line 7972: igs_lookups_view lkps

7968: spt.attendance_type
7969: FROM igs_en_spa_terms spt,
7970: igs_en_stdnt_ps_att_all spa,
7971: igs_ps_ver_all ps,
7972: igs_lookups_view lkps
7973: WHERE spt.person_id = spa.person_id
7974: AND spt.program_cd = spa.course_cd
7975: AND spt.program_version = spa.version_number
7976: AND spt.person_id = p_person_id