eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_EN_SPA_TERMS_API dependencies on IGS_CA_INST_REL

Line 48: FROM igs_ca_inst_rel

44: -- Check if the term calendar is subordinate to the acad cal type
45: -- as defined in its term record
46: cursor c_term_acad IS
47: SELECT 'x'
48: FROM igs_ca_inst_rel
49: WHERE sub_cal_type = p_term_rec.term_cal_type
50: AND sub_ci_sequence_number = p_term_rec.term_sequence_number
51: AND sup_cal_type = p_term_rec.acad_cal_type;
52:

Line 130: FROM igs_ca_inst_rel

126:
127: -- Check if the academic calendar for the key determined is same as that of passed in term.
128: CURSOR c_key_in_same_acad(cp_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE) IS
129: SELECT 'x'
130: FROM igs_ca_inst_rel
131: WHERE sub_cal_type = p_term_cal_type
132: and sub_ci_sequence_number = p_term_sequence_number
133: and sup_cal_type = cp_acad_cal_type;
134:

Line 198: FROM IGS_CA_INST_REL

194: CI1.CAL_TYPE = p_term_cal_type AND
195: CI1.SEQUENCE_NUMBER = p_term_sequence_number AND
196: CI1.START_DT > CI2.START_DT AND
197: SPAT.ACAD_CAL_TYPE IN (SELECT SUP_CAL_TYPE
198: FROM IGS_CA_INST_REL
199: WHERE SUB_CAL_TYPE = P_TERM_CAL_TYPE
200: AND SUB_CI_SEQUENCE_NUMBER = P_TERM_SEQUENCE_NUMBER)
201: ORDER BY CI2.START_DT DESC;
202:

Line 661: IGS_CA_INST_REL cr,

657: cp_program_version NUMBER,
658: cp_acad_cal_type igs_ca_inst.cal_type%TYPE) IS
659: SELECT spat.*
660: FROM IGS_EN_SPA_TERMS spat,
661: IGS_CA_INST_REL cr,
662: IGS_CA_INST_REL cr2,
663: IGS_CA_INST ci,
664: IGS_PS_VER cv
665: WHERE cr.sup_cal_type = cp_acad_cal_type

Line 662: IGS_CA_INST_REL cr2,

658: cp_acad_cal_type igs_ca_inst.cal_type%TYPE) IS
659: SELECT spat.*
660: FROM IGS_EN_SPA_TERMS spat,
661: IGS_CA_INST_REL cr,
662: IGS_CA_INST_REL cr2,
663: IGS_CA_INST ci,
664: IGS_PS_VER cv
665: WHERE cr.sup_cal_type = cp_acad_cal_type
666: AND cr.sub_cal_type = p_term_cal_type

Line 784: igs_ca_inst_rel cr,

780: igs_ca_inst endterm,
781: igs_ca_inst beginterm,
782: igs_ca_type ct,
783: igs_ca_stat cs,
784: igs_ca_inst_rel cr,
785: igs_ca_inst_rel cr2,
786: igs_ca_type ct2
787: WHERE ci.cal_type = cr.sub_cal_type
788: AND ci.sequence_number = cr.sub_ci_sequence_number

Line 785: igs_ca_inst_rel cr2,

781: igs_ca_inst beginterm,
782: igs_ca_type ct,
783: igs_ca_stat cs,
784: igs_ca_inst_rel cr,
785: igs_ca_inst_rel cr2,
786: igs_ca_type ct2
787: WHERE ci.cal_type = cr.sub_cal_type
788: AND ci.sequence_number = cr.sub_ci_sequence_number
789: AND cr.sup_cal_type = ct2.cal_type

Line 1010: IGS_CA_INST_REL cr,

1006: IGS_CA_INST ci2,
1007: IGS_CA_INST ci3,
1008: IGS_CA_TYPE ct,
1009: IGS_CA_STAT cs,
1010: IGS_CA_INST_REL cr,
1011: IGS_CA_INST_REL cr2,
1012: IGS_CA_TYPE ct2
1013: WHERE ci.cal_type = cr.sub_cal_type
1014: AND ci.sequence_number = cr.sub_ci_sequence_number

Line 1011: IGS_CA_INST_REL cr2,

1007: IGS_CA_INST ci3,
1008: IGS_CA_TYPE ct,
1009: IGS_CA_STAT cs,
1010: IGS_CA_INST_REL cr,
1011: IGS_CA_INST_REL cr2,
1012: IGS_CA_TYPE ct2
1013: WHERE ci.cal_type = cr.sub_cal_type
1014: AND ci.sequence_number = cr.sub_ci_sequence_number
1015: AND cr.sup_cal_type = ct2.cal_type

Line 1322: FROM igs_en_spa_terms spat, igs_ca_inst ca, igs_ca_inst_rel cir

1318: AND spat.key_program_flag = 'Y';
1319:
1320: CURSOR c_latest_term_in_acad IS -- check if the latest term in acad is for this program
1321: SELECT spat.rowid, spat.program_cd, term_cal_type, term_sequence_number
1322: FROM igs_en_spa_terms spat, igs_ca_inst ca, igs_ca_inst_rel cir
1323: WHERE spat.person_id = p_person_id
1324: AND ca.cal_type = spat.term_cal_type
1325: AND ca.sequence_number = spat.term_sequence_number
1326: AND cir.sub_cal_type = p_term_cal_type

Line 1342: IGS_CA_INST_REL cr,

1338:
1339: CURSOR c_dest_fut_terms IS
1340: SELECT spat.rowid,spat.*
1341: FROM IGS_EN_SPA_TERMS spat,
1342: IGS_CA_INST_REL cr,
1343: IGS_CA_INST_REL cr2,
1344: IGS_CA_INST ci,
1345: IGS_PS_VER cv
1346: WHERE cr.sub_cal_type = p_term_cal_type

Line 1343: IGS_CA_INST_REL cr2,

1339: CURSOR c_dest_fut_terms IS
1340: SELECT spat.rowid,spat.*
1341: FROM IGS_EN_SPA_TERMS spat,
1342: IGS_CA_INST_REL cr,
1343: IGS_CA_INST_REL cr2,
1344: IGS_CA_INST ci,
1345: IGS_PS_VER cv
1346: WHERE cr.sub_cal_type = p_term_cal_type
1347: AND cr.sub_ci_sequence_number = p_term_sequence_number

Line 1544: FROM IGS_CA_INST_REL

1540: CI1.CAL_TYPE = p_term_cal_type AND
1541: CI1.SEQUENCE_NUMBER = p_term_sequence_number AND
1542: CI1.START_DT > CI2.START_DT AND
1543: SPAT.ACAD_CAL_TYPE IN (SELECT SUP_CAL_TYPE
1544: FROM IGS_CA_INST_REL
1545: WHERE SUB_CAL_TYPE = CI1.CAL_TYPE
1546: AND SUB_CI_SEQUENCE_NUMBER = CI1.SEQUENCE_NUMBER)
1547: ORDER BY CI2.START_DT DESC;
1548:

Line 1622: FROM IGS_CA_INST_REL

1618: CI1.CAL_TYPE = p_term_cal_type AND
1619: CI1.SEQUENCE_NUMBER = p_term_sequence_number AND
1620: CI1.START_DT > CI2.START_DT AND
1621: SPAT.ACAD_CAL_TYPE IN (SELECT SUP_CAL_TYPE
1622: FROM IGS_CA_INST_REL
1623: WHERE SUB_CAL_TYPE = CI1.CAL_TYPE
1624: AND SUB_CI_SEQUENCE_NUMBER = CI1.SEQUENCE_NUMBER)
1625: ORDER BY CI2.START_DT DESC;
1626:

Line 1700: FROM IGS_CA_INST_REL

1696: CI1.CAL_TYPE = p_term_cal_type AND
1697: CI1.SEQUENCE_NUMBER = p_term_sequence_number AND
1698: CI1.START_DT > CI2.START_DT AND
1699: SPAT.ACAD_CAL_TYPE IN (SELECT SUP_CAL_TYPE
1700: FROM IGS_CA_INST_REL
1701: WHERE SUB_CAL_TYPE = CI1.CAL_TYPE
1702: AND SUB_CI_SEQUENCE_NUMBER = CI1.SEQUENCE_NUMBER)
1703: ORDER BY CI2.START_DT DESC;
1704:

Line 1778: FROM IGS_CA_INST_REL

1774: CI1.CAL_TYPE = p_term_cal_type AND
1775: CI1.SEQUENCE_NUMBER = p_term_sequence_number AND
1776: CI1.START_DT > CI2.START_DT AND
1777: SPAT.ACAD_CAL_TYPE IN (SELECT SUP_CAL_TYPE
1778: FROM IGS_CA_INST_REL
1779: WHERE SUB_CAL_TYPE = CI1.CAL_TYPE
1780: AND SUB_CI_SEQUENCE_NUMBER = CI1.SEQUENCE_NUMBER)
1781: ORDER BY CI2.START_DT DESC;
1782:

Line 1856: FROM IGS_CA_INST_REL

1852: CI1.CAL_TYPE = p_term_cal_type AND
1853: CI1.SEQUENCE_NUMBER = p_term_sequence_number AND
1854: CI1.START_DT > CI2.START_DT AND
1855: SPAT.ACAD_CAL_TYPE IN (SELECT SUP_CAL_TYPE
1856: FROM IGS_CA_INST_REL
1857: WHERE SUB_CAL_TYPE = CI1.CAL_TYPE
1858: AND SUB_CI_SEQUENCE_NUMBER = CI1.SEQUENCE_NUMBER)
1859: ORDER BY CI2.START_DT DESC;
1860:

Line 1934: FROM IGS_CA_INST_REL

1930: CI1.CAL_TYPE = p_term_cal_type AND
1931: CI1.SEQUENCE_NUMBER = p_term_sequence_number AND
1932: CI1.START_DT > CI2.START_DT AND
1933: SPAT.ACAD_CAL_TYPE IN (SELECT SUP_CAL_TYPE
1934: FROM IGS_CA_INST_REL
1935: WHERE SUB_CAL_TYPE = CI1.CAL_TYPE
1936: AND SUB_CI_SEQUENCE_NUMBER = CI1.SEQUENCE_NUMBER)
1937: ORDER BY CI2.START_DT DESC;
1938:

Line 2012: FROM IGS_CA_INST_REL

2008: CI1.CAL_TYPE = p_term_cal_type AND
2009: CI1.SEQUENCE_NUMBER = p_term_sequence_number AND
2010: CI1.START_DT > CI2.START_DT AND
2011: SPAT.ACAD_CAL_TYPE IN (SELECT SUP_CAL_TYPE
2012: FROM IGS_CA_INST_REL
2013: WHERE SUB_CAL_TYPE = CI1.CAL_TYPE
2014: AND SUB_CI_SEQUENCE_NUMBER = CI1.SEQUENCE_NUMBER)
2015: ORDER BY CI2.START_DT DESC;
2016:

Line 2518: igs_ca_inst_rel cir,

2514: CURSOR cur_c1(p_cur_term_cal IN VARCHAR2,
2515: p_cur_term_seq_num IN NUMBER) IS
2516: SELECT RPAD(ci2.sequence_number,6,' ') || ci2.cal_Type
2517: FROM igs_ca_inst ci2,
2518: igs_ca_inst_rel cir,
2519: igs_ca_type ct,
2520: igs_ca_inst ci1,
2521: igs_ca_stat cs
2522: WHERE

Line 2588: igs_ca_inst_rel cir,

2584: CURSOR cur_c1(p_cur_term_cal IN VARCHAR2,
2585: p_cur_term_seq_num IN NUMBER) IS
2586: SELECT RPAD(ci2.sequence_number,6,' ') || ci2.cal_type
2587: FROM igs_ca_inst ci2,
2588: igs_ca_inst_rel cir,
2589: igs_ca_type ct,
2590: igs_ca_inst ci1,
2591: igs_ca_stat cs
2592: WHERE

Line 2667: FROM IGS_CA_INST_REL

2663: CI1.CAL_TYPE = p_term_cal_type AND
2664: CI1.SEQUENCE_NUMBER = p_term_sequence_number AND
2665: CI1.START_DT > CI2.START_DT AND
2666: SPAT.ACAD_CAL_TYPE IN (SELECT SUP_CAL_TYPE
2667: FROM IGS_CA_INST_REL
2668: WHERE SUB_CAL_TYPE = CI1.CAL_TYPE
2669: AND SUB_CI_SEQUENCE_NUMBER = CI1.SEQUENCE_NUMBER)
2670: ORDER BY CI2.START_DT DESC;
2671: