APPS.IGS_EN_GEN_006 dependencies on IGS_PS_OFR_PAT

Line 624: v_cop_offered_ind IGS_PS_OFR_PAT.offered_ind%TYPE;

620: v_adm_cndtnl_offer_status IGS_AD_PS_APPL_INST_APLINST_V.ADM_CNDTNL_OFFER_STATUS%TYPE;
621: v_cndtnl_off_must_be_stsfd_ind IGS_AD_PS_APPL_INST_APLINST_V.cndtnl_offer_must_be_stsfd_ind%TYPE;
622: v_discontinued_dt IGS_EN_STDNT_PS_ATT.discontinued_dt%TYPE;
623: v_lapsed_dt IGS_EN_STDNT_PS_ATT.lapsed_dt%TYPE;
624: v_cop_offered_ind IGS_PS_OFR_PAT.offered_ind%TYPE;
625: v_s_adm_cndtnl_offer_status IGS_LOOKUPS_view.lookup_code%TYPE DEFAULT NULL;
626:
627: --modified cursor for performance bug 4968380
628: CURSOR c_person IS

Line 695: cp_coo_id IGS_PS_OFR_PAT.coo_id%TYPE,

691: WHERE sca.person_id = p_person_id AND
692: sca.course_cd = p_course_cd;
693:
694: CURSOR c_cop(
695: cp_coo_id IGS_PS_OFR_PAT.coo_id%TYPE,
696: cp_ci_sequence_number IGS_PS_OFR_PAT.ci_sequence_number%TYPE) IS
697:
698: SELECT cop.offered_ind
699: FROM IGS_PS_OFR_PAT cop

Line 696: cp_ci_sequence_number IGS_PS_OFR_PAT.ci_sequence_number%TYPE) IS

692: sca.course_cd = p_course_cd;
693:
694: CURSOR c_cop(
695: cp_coo_id IGS_PS_OFR_PAT.coo_id%TYPE,
696: cp_ci_sequence_number IGS_PS_OFR_PAT.ci_sequence_number%TYPE) IS
697:
698: SELECT cop.offered_ind
699: FROM IGS_PS_OFR_PAT cop
700: WHERE cop.coo_id = cp_coo_id AND

Line 699: FROM IGS_PS_OFR_PAT cop

695: cp_coo_id IGS_PS_OFR_PAT.coo_id%TYPE,
696: cp_ci_sequence_number IGS_PS_OFR_PAT.ci_sequence_number%TYPE) IS
697:
698: SELECT cop.offered_ind
699: FROM IGS_PS_OFR_PAT cop
700: WHERE cop.coo_id = cp_coo_id AND
701: cop.ci_sequence_number = cp_ci_sequence_number;
702:
703: CURSOR c_sci IS