APPS.IGS_HE_EXTRACT_PKG dependencies on IGS_PS_GRP_MBR

Line 470: l_course_group_cd igs_ps_grp_mbr.course_group_cd%TYPE ;

466: AND sequence_number = p_sequence_number;
467:
468:
469: l_course_cat igs_ps_categorise.course_cat%TYPE ;
470: l_course_group_cd igs_ps_grp_mbr.course_group_cd%TYPE ;
471: l_hesa_special_student igs_he_code_map_val.map1%TYPE ;
472: l_ad_special_student igs_he_code_map_val.map1%TYPE ;
473: l_dummy VARCHAR2(50);
474: l_dormant BOOLEAN := FALSE;

Line 523: FROM igs_ps_grp_mbr

519: CURSOR c_prg_grp_excl
520: (p_course_cd VARCHAR2,
521: p_version_number NUMBER ) IS
522: SELECT 'X'
523: FROM igs_ps_grp_mbr
524: WHERE course_cd = p_course_cd
525: AND version_number = p_version_number
526: AND course_group_cd IN ( SELECT exclude FROM igs_he_ext_run_prms
527: WHERE extract_run_id = p_extract_run_id

Line 535: FROM igs_ps_grp_mbr

531: CURSOR c_prg_grp_only
532: (p_course_cd VARCHAR2,
533: p_version_number NUMBER ) IS
534: SELECT 'X'
535: FROM igs_ps_grp_mbr
536: WHERE course_cd = p_course_cd
537: AND version_number = p_version_number
538: AND course_group_cd IN ( SELECT only FROM igs_he_ext_run_prms
539: WHERE extract_run_id = p_extract_run_id