APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on IGS_PE_RES_DTLS_V

Line 842: -- jtmathew modified this cursor for bug 5210481 to remove igs_pe_res_dtls_v view

838:
839: -- smaddali modified this cursor for bug 2730388 to get only open code values
840: -- smaddali modified this cursor for bug 2367167 to get records which are effective in the HESA submission period, bug#3235753
841: -- anwest modified this cursor for HE356 to get open and closed values and not restricted to OSS_RESIDENCY_OS
842: -- jtmathew modified this cursor for bug 5210481 to remove igs_pe_res_dtls_v view
843: CURSOR c_res_sts (cp_res_class_cd VARCHAR2) IS
844: SELECT peresdtls.residency_status_cd residency_status
845: FROM igs_pe_res_dtls_all peresdtls,
846: igs_lookup_values cc1,

Line 869: l_residency_status igs_pe_res_dtls_v.residency_status%TYPE;

865: WHERE hecodeval.code_type = 'OSS_RESIDENCY_OS'
866: AND hecodeval.value = cp_res_stat_cd
867: AND NVL(hecodeval.closed_ind,'N') = 'N' ;
868:
869: l_residency_status igs_pe_res_dtls_v.residency_status%TYPE;
870: l_oss_fund_cd VARCHAR2(30);
871: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;
872: l_res_class_cd igs_pe_res_dtls_v.residency_class%TYPE;
873: l_dummy VARCHAR2(1);

Line 872: l_res_class_cd igs_pe_res_dtls_v.residency_class%TYPE;

868:
869: l_residency_status igs_pe_res_dtls_v.residency_status%TYPE;
870: l_oss_fund_cd VARCHAR2(30);
871: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;
872: l_res_class_cd igs_pe_res_dtls_v.residency_class%TYPE;
873: l_dummy VARCHAR2(1);
874:
875: BEGIN
876:

Line 3342: -- jtmathew modified this cursor for bug 5210481 to remove igs_pe_res_dtls_v view

3338: ***************************************************************/
3339:
3340: -- smaddali modified this cursor for bug 2367167 to get records which are effective in the HESA submission period, bug#3235753
3341: -- anwest modified this cursor for HE356 to accommodate Term/Load Calendar for Residency Status
3342: -- jtmathew modified this cursor for bug 5210481 to remove igs_pe_res_dtls_v view
3343: CURSOR c_res_sts (cp_res_class_cd VARCHAR2) IS
3344: SELECT peresdtls.residency_status_cd residency_status
3345: FROM igs_pe_res_dtls_all peresdtls,
3346: igs_lookup_values cc1,

Line 3360: l_residency_status igs_pe_res_dtls_v.residency_status%TYPE;

3356: AND peresdtls.sequence_number = cainstall.sequence_number
3357: AND cainstall.start_dt <= p_enrl_end_dt
3358: ORDER BY cainstall.start_dt DESC;
3359:
3360: l_residency_status igs_pe_res_dtls_v.residency_status%TYPE;
3361: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;
3362: l_oss_fee_elig igs_he_code_map_val.map1%TYPE;
3363: l_res_class_cd igs_pe_res_dtls_v.residency_class%TYPE;
3364:

Line 3363: l_res_class_cd igs_pe_res_dtls_v.residency_class%TYPE;

3359:
3360: l_residency_status igs_pe_res_dtls_v.residency_status%TYPE;
3361: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;
3362: l_oss_fee_elig igs_he_code_map_val.map1%TYPE;
3363: l_res_class_cd igs_pe_res_dtls_v.residency_class%TYPE;
3364:
3365: BEGIN
3366:
3367: IF p_susa_fee_elig IS NOT NULL