APPS.IGS_PS_VALIDATE_LGCY_PKG dependencies on IGS_PS_UNIT_GRD_SCHM

Line 584: FROM igs_ps_unit_grd_schm

580: cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
581: cp_ver_num igs_ps_unit_ver_all.version_number%TYPE
582: ) IS
583: SELECT COUNT(*) cnt
584: FROM igs_ps_unit_grd_schm
585: WHERE
586: unit_code = cp_unit_cd AND
587: unit_version_number = cp_ver_num AND
588: default_flag = 'Y';

Line 2793: CURSOR c_gs_exists ( cp_gs_cd igs_ps_unit_grd_schm.grading_schema_code%TYPE,

2789: Known limitations,enhancements,remarks:
2790: Change History (in reverse chronological order)
2791: Who When What
2792: ********************************************************************************************** */
2793: CURSOR c_gs_exists ( cp_gs_cd igs_ps_unit_grd_schm.grading_schema_code%TYPE,
2794: cp_gs_ver igs_ps_unit_grd_schm.grd_schm_version_number%TYPE,
2795: cp_gs_type igs_as_grd_schema.grading_schema_type%TYPE ) IS
2796: SELECT 1
2797: FROM igs_as_grd_schema

Line 2794: cp_gs_ver igs_ps_unit_grd_schm.grd_schm_version_number%TYPE,

2790: Change History (in reverse chronological order)
2791: Who When What
2792: ********************************************************************************************** */
2793: CURSOR c_gs_exists ( cp_gs_cd igs_ps_unit_grd_schm.grading_schema_code%TYPE,
2794: cp_gs_ver igs_ps_unit_grd_schm.grd_schm_version_number%TYPE,
2795: cp_gs_type igs_as_grd_schema.grading_schema_type%TYPE ) IS
2796: SELECT 1
2797: FROM igs_as_grd_schema
2798: WHERE