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_CA_INS_ROLL_CI dependencies on DUAL

Line 1265: FROM DUAL;

1261: v_new_absolute_val IGS_CA_DA_INST_V.absolute_val%TYPE;
1262: v_new_sequence_number IGS_CA_DA_INST_V.sequence_number%TYPE;
1263: CURSOR c_dai_sequence_number IS
1264: SELECT IGS_CA_DA_INST_SEQ_NUM_S.nextval
1265: FROM DUAL;
1266: CURSOR c_dt_alias_instance(
1267: cp_cal_type IGS_CA_DA_INST_V.CAL_TYPE%TYPE,
1268: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE) IS
1269: SELECT *

Line 2180: FROM DUAL;

2176: FROM IGS_CA_TYPE
2177: WHERE CAL_TYPE = cp_cal_type;
2178: CURSOR c_ci_sequence_number IS
2179: SELECT IGS_CA_INST_SEQ_NUM_S.nextval
2180: FROM DUAL;
2181:
2182: -- Sequence to get unique value for alternate codes bug - 2563531
2183: CURSOR alt_uniq_seq IS
2184: SELECT igs_ca_inst_seq_num_s1.nextval from DUAL;

Line 2184: SELECT igs_ca_inst_seq_num_s1.nextval from DUAL;

2180: FROM DUAL;
2181:
2182: -- Sequence to get unique value for alternate codes bug - 2563531
2183: CURSOR alt_uniq_seq IS
2184: SELECT igs_ca_inst_seq_num_s1.nextval from DUAL;
2185: -- cursor to check whether the alternate code for academic calendar instance is already present.
2186: CURSOR alt_code_unique(p_alternate_code IGS_CA_INST.ALTERNATE_CODE%TYPE) IS
2187: SELECT count(*)
2188: FROM IGS_CA_INST CI , IGS_CA_TYPE CAT

Line 2545: FROM dual;

2541: t2_rollover_ci t2_rollover_ci_table;
2542: t2_rollover_ci_index BINARY_INTEGER;
2543: CURSOR c_ci_rollover_sequence_number IS
2544: SELECT IGS_CA_INST_REL_SUP_CI_SNO_S1.NEXTVAL
2545: FROM dual;
2546: CURSOR c_cir1 IS
2547: SELECT *
2548: FROM IGS_CA_INST_REL
2549: WHERE sup_cal_type = p_cal_type AND