APPS.IGS_AS_GEN_006 dependencies on IGS_CO_OU_CO_REF

Line 1226: IGS_CO_OU_CO_REF ocr

1222: (
1223: NOT EXISTS ( SELECT
1224: 'X'
1225: FROM
1226: IGS_CO_OU_CO_REF ocr
1227: WHERE
1228: ocr.person_id = suaai.person_id AND
1229: ocr.correspondence_type = cst_coversheet AND
1230: ocr.cal_type = suaai.cal_type AND

Line 1391: v_ocr_sequence_number IGS_CO_OU_CO_REF.sequence_number%TYPE;

1387: v_ai_rec c_ai%ROWTYPE;
1388: v_record VARCHAR2(2000);
1389: v_message_name VARCHAR2(30);
1390: v_cori_sequence_number IGS_CO_ITM.reference_number%TYPE;
1391: v_ocr_sequence_number IGS_CO_OU_CO_REF.sequence_number%TYPE;
1392: BEGIN
1393: -- Select students who are enrolled and have an assignment assessment type.
1394: -- If p_reproduce = 'Y' then are interested only in the records that have had
1395: -- a sheet produced previously, otherwise if 'N', then only want records where