APPS.IGS_HE_EXTRACT_PKG dependencies on IGS_PS_CATEGORISE_ALL

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