APPS.IGS_SS_ENR_DETAILS dependencies on IGS_PS_USEC_GRD_SCHM

Line 858: igs_ps_usec_grd_schm usgr

854: CURSOR usec_grd_sch IS
855: SELECT
856: usgr.grading_schema_code
857: FROM
858: igs_ps_usec_grd_schm usgr
859: WHERE
860: usgr.uoo_id = p_uoo_id AND
861: usgr.default_flag = 'Y';
862:

Line 939: igs_ps_usec_grd_schm usgr

935: CURSOR usec_grd_sch IS
936: SELECT
937: usgr.grd_schm_version_number
938: FROM
939: igs_ps_usec_grd_schm usgr
940: WHERE
941: usgr.uoo_id = p_uoo_id AND
942: usgr.default_flag = 'Y';
943:

Line 1011: igs_ps_usec_grd_schm usgr

1007: SELECT
1008: usgr.grading_schema_code,
1009: usgr.grd_schm_version_number
1010: FROM
1011: igs_ps_usec_grd_schm usgr
1012: WHERE
1013: usgr.uoo_id = cp_n_uoo_id AND
1014: usgr.default_flag = 'Y';
1015:

Line 1103: igs_ps_usec_grd_schm usgr

1099: SELECT
1100: usgr.grading_schema_code,
1101: usgr.grd_schm_version_number
1102: FROM
1103: igs_ps_usec_grd_schm usgr
1104: WHERE
1105: usgr.uoo_id = cp_n_uoo_id AND
1106: usgr.default_flag = 'Y';
1107: