APPS.IGS_SS_ENR_DETAILS dependencies on IGS_PS_UNIT_GRD_SCHM

Line 868: igs_ps_unit_grd_schm uvgr

864: CURSOR unit_grd_sch IS
865: SELECT
866: grading_schema_code
867: FROM
868: igs_ps_unit_grd_schm uvgr
869: WHERE
870: uvgr.unit_code = p_unit_cd AND
871: uvgr.unit_version_number = p_version_number AND
872: uvgr.default_flag = 'Y';

Line 949: igs_ps_unit_grd_schm uvgr

945: CURSOR unit_grd_sch IS
946: SELECT
947: grd_schm_version_number
948: FROM
949: igs_ps_unit_grd_schm uvgr
950: WHERE
951: uvgr.unit_code = p_unit_cd AND
952: uvgr.unit_version_number = p_version_number AND
953: uvgr.default_flag = 'Y';

Line 1023: igs_ps_unit_grd_schm uvgr

1019: SELECT
1020: uvgr.grading_schema_code,
1021: uvgr.grd_schm_version_number
1022: FROM
1023: igs_ps_unit_grd_schm uvgr
1024: WHERE
1025: uvgr.unit_code = cp_c_unit_cd AND
1026: uvgr.unit_version_number = cp_n_ver_num AND
1027: uvgr.default_flag = 'Y';

Line 1115: igs_ps_unit_grd_schm uvgr

1111: SELECT
1112: uvgr.grading_schema_code,
1113: uvgr.grd_schm_version_number
1114: FROM
1115: igs_ps_unit_grd_schm uvgr
1116: WHERE
1117: uvgr.unit_code = cp_c_unit_cd AND
1118: uvgr.unit_version_number = cp_n_ver_num AND
1119: uvgr.default_flag = 'Y';