APPS.IGS_AS_PRC_TRANSCRPT dependencies on IGS_AS_GEN_001

Line 1244: AND igs_as_gen_001.assp_val_sua_display (suav.person_id,

1240: AND uv.unit_cd = suav.unit_cd
1241: AND uv.version_number = suav.version_number
1242: AND suav.uoo_id = cps.uoo_id(+)
1243: AND suav.unit_attempt_status NOT IN ('UNCONFIRM', 'DUPLICATE')
1244: AND igs_as_gen_001.assp_val_sua_display (suav.person_id,
1245: suav.course_cd,
1246: sca.version_number,
1247: suav.unit_cd,
1248: suav.cal_type,

Line 2049: IGS_AS_GEN_001.ASSP_VAL_SUA_DISPLAY(

2045: WHERE sua.person_id = suav.person_id AND
2046: sua.course_cd = suav.course_cd AND
2047: -- anilk, 22-Apr-2003, Bug# 2829262
2048: sua.uoo_id = suav.uoo_id AND
2049: IGS_AS_GEN_001.ASSP_VAL_SUA_DISPLAY(
2050: sua.person_id,
2051: sua.course_cd,
2052: sca.version_number,
2053: sua.unit_cd,

Line 2144: IGS_AS_GEN_001.ASSP_VAL_SUA_DISPLAY(

2140: WHERE sua.person_id = suav.person_id AND
2141: sua.course_cd = suav.course_cd AND
2142: -- anilk, 22-Apr-2003, Bug# 2829262
2143: sua.uoo_id = suav.uoo_id AND
2144: IGS_AS_GEN_001.ASSP_VAL_SUA_DISPLAY(
2145: sua.person_id,
2146: sua.course_cd,
2147: sca.version_number,
2148: sua.unit_cd,