APPS.IGS_AS_GEN_003 dependencies on IGS_AS_VAL_UAI

Line 882: IGS_AS_VAL_UAI.assp_val_sua_ai_acot(usai.ass_id,

878: sua.uoo_id = p_uoo_id AND
879: usai.ass_id = p_ass_id AND
880: usai.logical_delete_dt IS NULL AND
881: sua.uoo_id = usai.uoo_id AND
882: IGS_AS_VAL_UAI.assp_val_sua_ai_acot(usai.ass_id,
883: sua.person_id,
884: sua.course_cd) = 'TRUE';
885:
886: -- This cursor selects the due date of the assessment item at unit section level for

Line 905: IGS_AS_VAL_UAI.assp_val_sua_ai_acot(usai.ass_id,

901: SELECT MAX(usai1.logical_delete_dt)
902: FROM igs_ps_unitass_item usai1
903: WHERE usai1.uoo_id = sua.uoo_id and
904: usai1.ass_id = usai.ass_id) AND
905: IGS_AS_VAL_UAI.assp_val_sua_ai_acot(usai.ass_id,
906: sua.person_id,
907: sua.course_cd) = 'TRUE';
908:
909: CURSOR c_suv IS

Line 923: IGS_AS_VAL_UAI.assp_val_sua_ai_acot(uai.ass_id,

919: sua.unit_cd = uai.unit_cd AND
920: sua.version_number = uai.version_number AND
921: sua.cal_type = uai.cal_type AND
922: sua.ci_sequence_number = uai.ci_sequence_number AND
923: IGS_AS_VAL_UAI.assp_val_sua_ai_acot(uai.ass_id,
924: sua.person_id,
925: sua.course_cd) = 'TRUE';
926:
927: CURSOR c_suv_del IS

Line 949: IGS_AS_VAL_UAI.assp_val_sua_ai_acot(uai.ass_id,

945: sua.unit_cd = uai.unit_cd AND
946: sua.version_number = uai.version_number AND
947: sua.cal_type = uai.cal_type AND
948: sua.ci_sequence_number = uai.ci_sequence_number AND
949: IGS_AS_VAL_UAI.assp_val_sua_ai_acot(uai.ass_id,
950: sua.person_id,
951: sua.course_cd) = 'TRUE'
952: );
953: BEGIN

Line 1030: IGS_AS_VAL_UAI.assp_val_sua_ai_acot(usai.ass_id,

1026: sua.uoo_id = p_uoo_id AND
1027: usai.ass_id = p_ass_id AND
1028: usai.logical_delete_dt IS NULL AND
1029: sua.uoo_id = usai.uoo_id AND
1030: IGS_AS_VAL_UAI.assp_val_sua_ai_acot(usai.ass_id,
1031: sua.person_id,
1032: sua.course_cd) = 'TRUE';
1033:
1034: -- This cursor selects the reference of the assessment item at unit section level for

Line 1053: IGS_AS_VAL_UAI.assp_val_sua_ai_acot(usai.ass_id,

1049: SELECT MAX(usai1.logical_delete_dt)
1050: FROM igs_ps_unitass_item usai1
1051: WHERE usai1.uoo_id = sua.uoo_id and
1052: usai1.ass_id = usai.ass_id) AND
1053: IGS_AS_VAL_UAI.assp_val_sua_ai_acot(usai.ass_id,
1054: sua.person_id,
1055: sua.course_cd) = 'TRUE';
1056:
1057: CURSOR c_suv IS

Line 1071: IGS_AS_VAL_UAI.assp_val_sua_ai_acot(uai.ass_id,

1067: sua.unit_cd = uai.unit_cd AND
1068: sua.version_number = uai.version_number AND
1069: sua.cal_type = uai.cal_type AND
1070: sua.ci_sequence_number = uai.ci_sequence_number AND
1071: IGS_AS_VAL_UAI.assp_val_sua_ai_acot(uai.ass_id,
1072: sua.person_id,
1073: sua.course_cd) = 'TRUE';
1074:
1075:

Line 1098: IGS_AS_VAL_UAI.assp_val_sua_ai_acot(uai.ass_id,

1094: sua.unit_cd = uai.unit_cd AND
1095: sua.version_number = uai.version_number AND
1096: sua.cal_type = uai.cal_type AND
1097: sua.ci_sequence_number = uai.ci_sequence_number AND
1098: IGS_AS_VAL_UAI.assp_val_sua_ai_acot(uai.ass_id,
1099: sua.person_id,
1100: sua.course_cd) = 'TRUE'
1101: );
1102: BEGIN