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_GEN_001 dependencies on IGS_GE_S_GEN_CAL_CON

Line 206: v_census_dt_alias IGS_GE_S_GEN_CAL_CON.census_dt_alias%TYPE;

202: cst_before CONSTANT VARCHAR2(8) := 'BEFORE';
203: cst_current CONSTANT VARCHAR2(8) := 'CURRENT';
204: cst_after CONSTANT VARCHAR2(8) := 'AFTER';
205: cst_null CONSTANT VARCHAR2(4) := 'NULL';
206: v_census_dt_alias IGS_GE_S_GEN_CAL_CON.census_dt_alias%TYPE;
207: v_start_dt IGS_CA_INST.start_dt%TYPE;
208: v_end_dt IGS_CA_INST.end_dt%TYPE;
209: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
210: v_within BOOLEAN;

Line 215: FROM IGS_GE_S_GEN_CAL_CON sgcc

211: v_before BOOLEAN;
212: v_after BOOLEAN;
213: CURSOR c_sgcc IS
214: SELECT sgcc.census_dt_alias
215: FROM IGS_GE_S_GEN_CAL_CON sgcc
216: WHERE sgcc.s_control_num = 1;
217: CURSOR c_ci (
218: cp_source_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
219: cp_source_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

Line 228: cp_census_dt_alias IGS_GE_S_GEN_CAL_CON.census_dt_alias%TYPE) IS

224: ci.sequence_number = cp_source_ci_sequence_number;
225: CURSOR c_daiv (
226: cp_related_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
227: cp_related_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
228: cp_census_dt_alias IGS_GE_S_GEN_CAL_CON.census_dt_alias%TYPE) IS
229: SELECT daiv.alias_val
230: FROM IGS_CA_DA_INST_V daiv
231: WHERE daiv.CAL_TYPE = cp_related_cal_type AND
232: daiv.ci_sequence_number = cp_related_ci_sequence_number AND