APPS.IGF_AW_COA_GEN dependencies on IGS_EN_SPA_TERMS

Line 1286: FROM igs_en_spa_terms key,

1282: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
1283: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
1284: ) IS
1285: SELECT ps.responsible_org_unit_cd,1 record_order
1286: FROM igs_en_spa_terms key,
1287: igs_ps_ver ps
1288: WHERE key.key_program_flag = 'Y'
1289: AND person_id = cp_person_id
1290: AND ps.course_cd = key.program_cd

Line 1312: FROM igs_en_spa_terms sp,

1308: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
1309: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
1310: ) IS
1311: SELECT pt.course_type,1 record_order
1312: FROM igs_en_spa_terms sp,
1313: igs_ps_ver pv,
1314: igs_ps_type_v pt
1315: WHERE sp.key_program_flag = 'Y'
1316: AND sp.program_cd = pv.course_cd

Line 1342: FROM igs_en_spa_terms

1338: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
1339: ) IS
1340: SELECT location_cd,
1341: 1 record_order
1342: FROM igs_en_spa_terms
1343: WHERE key_program_flag = 'Y'
1344: AND person_id = cp_person_id
1345: AND term_cal_type = cp_ld_cal_type
1346: AND term_sequence_number = cp_ld_sequence_number

Line 1364: FROM igs_en_spa_terms

1360: ) IS
1361: SELECT program_cd,
1362: program_version,
1363: 1 record_order
1364: FROM igs_en_spa_terms
1365: WHERE key_program_flag = 'Y'
1366: AND person_id = cp_person_id
1367: AND term_cal_type = cp_ld_cal_type
1368: AND term_sequence_number = cp_ld_sequence_number

Line 1387: FROM igs_en_spa_terms

1383: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
1384: ) IS
1385: SELECT attendance_type,
1386: 1 record_order
1387: FROM igs_en_spa_terms
1388: WHERE key_program_flag = 'Y'
1389: AND person_id = cp_person_id
1390: AND term_cal_type = cp_ld_cal_type
1391: AND term_sequence_number = cp_ld_sequence_number

Line 1408: FROM igs_en_spa_terms

1404: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
1405: ) IS
1406: SELECT attendance_mode,
1407: 1 record_order
1408: FROM igs_en_spa_terms
1409: WHERE key_program_flag = 'Y'
1410: AND person_id = cp_person_id
1411: AND term_cal_type = cp_ld_cal_type
1412: AND term_sequence_number = cp_ld_sequence_number

Line 1885: FROM igs_en_spa_terms

1881: cp_program_code igs_ps_ver.course_cd%TYPE,
1882: cp_version_number igs_ps_ver.version_number%TYPE
1883: ) IS
1884: SELECT person_id
1885: FROM igs_en_spa_terms
1886: WHERE key_program_flag = 'Y'
1887: AND program_cd = cp_program_code
1888: AND program_version = cp_version_number;
1889: