DBA Data[Home] [Help]

APPS.IGS_PS_VALIDATE_GENERIC_PKG dependencies on IGS_PS_STAT

Line 2537: FROM igs_ps_ver pv, igs_ps_stat pvst

2533:
2534: CURSOR c_prog(cp_preference_code igs_ps_rsv_usec_prf.preference_code%TYPE,
2535: cp_preference_version igs_ps_rsv_usec_prf.preference_version%TYPE) IS
2536: SELECT 'X'
2537: FROM igs_ps_ver pv, igs_ps_stat pvst
2538: WHERE pvst.course_status = pv.course_status
2539: AND pvst.s_course_status <> 'INACTIVE'
2540: AND pv.course_cd=cp_preference_code
2541: AND pv.version_number=cp_preference_version;

Line 2686: FROM igs_ps_ver pv, igs_ps_stat pvst

2682:
2683: CURSOR c_prog(cp_preference_code igs_ps_rsv_usec_prf.preference_code%TYPE,
2684: cp_preference_version igs_ps_rsv_usec_prf.preference_version%TYPE) IS
2685: SELECT 'X'
2686: FROM igs_ps_ver pv, igs_ps_stat pvst
2687: WHERE pvst.course_status = pv.course_status
2688: AND pvst.s_course_status <> 'INACTIVE'
2689: AND pv.course_cd=cp_preference_code
2690: AND pv.version_number=cp_preference_version;