APPS.IGS_PR_GEN_006 dependencies on IGS_FI_ENC_DFLT_EFT

Line 1656: FROM igs_fi_enc_dflt_eft etde

1652: pee.expiry_dt > TRUNC(SYSDATE)) AND
1653: pee.s_encmb_effect_type IN
1654: (
1655: SELECT s_encmb_effect_type
1656: FROM igs_fi_enc_dflt_eft etde
1657: WHERE etde.encumbrance_type = cp_encumbrance_type);
1658: CURSOR c_spo_expire (
1659: cp_spo_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE) IS
1660: SELECT spo.*, spo.ROWID

Line 1671: FROM igs_fi_enc_dflt_eft edte

1667: v_spo_expire_rec c_spo_expire%ROWTYPE;
1668: CURSOR c_edte (
1669: cp_encumbrance_type igs_pr_ou_type.encumbrance_type%TYPE) IS
1670: SELECT edte.s_encmb_effect_type
1671: FROM igs_fi_enc_dflt_eft edte
1672: WHERE edte.encumbrance_type = cp_encumbrance_type AND
1673: edte.s_encmb_effect_type IN (
1674: cst_sus_course,
1675: cst_exc_course,

Line 2588: FROM igs_fi_enc_dflt_eft etde

2584: pen.spo_sequence_number = p_spo_sequence_number;
2585: CURSOR c_etde (
2586: cp_encumbrance_type IGS_PR_OU_TYPE.encumbrance_type%TYPE) IS
2587: SELECT etde.s_encmb_effect_type
2588: FROM igs_fi_enc_dflt_eft etde
2589: WHERE etde.encumbrance_type = cp_encumbrance_type;
2590:
2591: CURSOR c_pee IS
2592: SELECT pee.*,

Line 2596: igs_fi_enc_dflt_eft etde

2592: SELECT pee.*,
2593: pee.ROWID
2594: FROM IGS_PE_PERS_ENCUMB pen,
2595: IGS_PE_PERSENC_EFFCT pee,
2596: igs_fi_enc_dflt_eft etde
2597: WHERE pen.person_id = p_person_id AND
2598: pen.spo_course_cd = p_course_cd AND
2599: pen.spo_sequence_number = p_spo_sequence_number AND
2600: pen.person_id = pee.person_id AND

Line 2908: s_encmb_effect_type igs_fi_enc_dflt_eft.s_encmb_effect_type%TYPE);

2904: v_apply_to_course_ind igs_en_encmb_efcttyp.apply_to_course_ind%TYPE;
2905: v_apply_course_cd IGS_PE_PERSENC_EFFCT.course_cd%TYPE;
2906:
2907: TYPE r_etde_record_type IS RECORD (
2908: s_encmb_effect_type igs_fi_enc_dflt_eft.s_encmb_effect_type%TYPE);
2909: r_etde_record r_etde_record_type;
2910:
2911: TYPE t_etde_type IS TABLE OF r_etde_record%TYPE
2912: INDEX BY BINARY_INTEGER;

Line 3423: igs_fi_enc_dflt_eft etde

3419: SELECT pee.*,
3420: pee.ROWID
3421: FROM IGS_PE_PERS_ENCUMB pen,
3422: IGS_PE_PERSENC_EFFCT pee,
3423: igs_fi_enc_dflt_eft etde
3424: WHERE pen.person_id = p_person_id AND
3425: pen.spo_course_cd = p_course_cd AND
3426: pen.spo_sequence_number = p_spo_sequence_number AND
3427: pen.person_id = pee.person_id AND