APPS.IGF_AW_PACKNG_SUBFNS dependencies on IGS_PS_VER_ALL

Line 63: lv_course_type igs_ps_ver_all.course_type%TYPE;

59: || cursor c_get_status ref changed to pick active isisr
60: */
61:
62: lv_class_standing igs_pr_css_class_std_v.class_standing%TYPE;
63: lv_course_type igs_ps_ver_all.course_type%TYPE;
64:
65: CURSOR c_fabase_det IS
66: SELECT *
67: FROM igf_ap_fa_base_rec_all

Line 811: p_course_type OUT NOCOPY igs_ps_ver_all.course_type%TYPE,

807: p_base_id IN igf_ap_fa_base_rec.base_id%TYPE,
808: p_person_id IN igf_ap_fa_base_rec.person_id%TYPE,
809: p_adplans_id IN NUMBER,
810: p_award_id IN igf_aw_award_all.award_id%TYPE,
811: p_course_type OUT NOCOPY igs_ps_ver_all.course_type%TYPE,
812: p_awd_period IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL,
813: p_called_from IN VARCHAR2 DEFAULT 'NON-PACKAGING'
814: ) RETURN CHAR IS
815: