APPS.IGF_AW_COA_GEN dependencies on IGS_EN_STDNT_PS_ATT

Line 1297: FROM igs_en_stdnt_ps_att att,

1293: AND key.term_sequence_number = cp_ld_sequence_number
1294: UNION ALL
1295: SELECT ps.responsible_org_unit_cd,
1296: 2 record_order
1297: FROM igs_en_stdnt_ps_att att,
1298: igs_ps_ver ps
1299: WHERE att.person_id = cp_person_id
1300: AND att.key_program = 'Y'
1301: AND att.course_cd = ps.course_cd

Line 1324: FROM igs_en_stdnt_ps_att sp,

1320: AND sp.term_cal_type = cp_ld_cal_type
1321: AND sp.term_sequence_number = cp_ld_sequence_number
1322: UNION ALL
1323: SELECT pt.course_type,2 record_order
1324: FROM igs_en_stdnt_ps_att sp,
1325: igs_ps_ver pv,
1326: igs_ps_type_v pt
1327: WHERE sp.key_program = 'Y'
1328: AND sp.course_cd = pv.course_cd

Line 1350: FROM igs_en_stdnt_ps_att

1346: AND term_sequence_number = cp_ld_sequence_number
1347: UNION ALL
1348: SELECT location_cd,
1349: 2 record_order
1350: FROM igs_en_stdnt_ps_att
1351: WHERE key_program = 'Y'
1352: AND person_id = cp_person_id
1353: ORDER BY record_order;
1354:

Line 1373: FROM igs_en_stdnt_ps_att

1369: UNION ALL
1370: SELECT course_cd program_cd,
1371: version_number program_version,
1372: 2 record_order
1373: FROM igs_en_stdnt_ps_att
1374: WHERE key_program = 'Y'
1375: AND person_id = cp_person_id
1376: ORDER BY record_order;
1377:

Line 1395: FROM igs_en_stdnt_ps_att

1391: AND term_sequence_number = cp_ld_sequence_number
1392: UNION ALL
1393: SELECT attendance_type,
1394: 2 record_order
1395: FROM igs_en_stdnt_ps_att
1396: WHERE key_program = 'Y'
1397: AND person_id = cp_person_id
1398: ORDER BY record_order;
1399:

Line 1416: FROM igs_en_stdnt_ps_att

1412: AND term_sequence_number = cp_ld_sequence_number
1413: UNION ALL
1414: SELECT attendance_mode,
1415: 2 record_order
1416: FROM igs_en_stdnt_ps_att
1417: WHERE key_program = 'Y'
1418: AND person_id = cp_person_id
1419: ORDER BY record_order;
1420: