APPS.IGS_HE_EXTRACT_PKG dependencies on IGS_PS_CATEGORISE

Line 469: l_course_cat igs_ps_categorise.course_cat%TYPE ;

465: AND nominated_course_cd = p_nominated_course_cd
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);

Line 498: FROM igs_ps_categorise_all

494: CURSOR c_prg_cat_excl
495: (p_course_cd VARCHAR2,
496: p_version_number NUMBER ) IS
497: SELECT 'X'
498: FROM igs_ps_categorise_all
499: WHERE course_cd = p_course_cd
500: AND version_number = p_version_number
501: AND course_cat IN ( SELECT exclude FROM igs_he_ext_run_prms
502: WHERE extract_run_id = p_extract_run_id

Line 510: FROM igs_ps_categorise_all

506: CURSOR c_prg_cat_only
507: (p_course_cd VARCHAR2,
508: p_version_number NUMBER ) IS
509: SELECT 'X'
510: FROM igs_ps_categorise_all
511: WHERE course_cd = p_course_cd
512: AND version_number = p_version_number
513: AND course_cat IN ( SELECT only FROM igs_he_ext_run_prms
514: WHERE extract_run_id = p_extract_run_id