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

Line 45: CURSOR c_dai_v(cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,

41: CURSOR c_s_enr_cal_conf IS
42: SELECT effect_enr_strt_dt_alias
43: FROM IGS_EN_CAL_CONF
44: WHERE s_control_num = 1;
45: CURSOR c_dai_v(cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
46: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE,
47: cp_effective_dt DATE) IS
48: SELECT IGS_CA_DA_INST_V.alias_val,
49: IGS_CA_DA_INST_V.ci_sequence_number

Line 46: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE,

42: SELECT effect_enr_strt_dt_alias
43: FROM IGS_EN_CAL_CONF
44: WHERE s_control_num = 1;
45: CURSOR c_dai_v(cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
46: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE,
47: cp_effective_dt DATE) IS
48: SELECT IGS_CA_DA_INST_V.alias_val,
49: IGS_CA_DA_INST_V.ci_sequence_number
50: FROM IGS_CA_DA_INST_V,

Line 48: SELECT IGS_CA_DA_INST_V.alias_val,

44: WHERE s_control_num = 1;
45: CURSOR c_dai_v(cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
46: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE,
47: cp_effective_dt DATE) IS
48: SELECT IGS_CA_DA_INST_V.alias_val,
49: IGS_CA_DA_INST_V.ci_sequence_number
50: FROM IGS_CA_DA_INST_V,
51: IGS_CA_INST,
52: IGS_CA_STAT

Line 49: IGS_CA_DA_INST_V.ci_sequence_number

45: CURSOR c_dai_v(cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
46: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE,
47: cp_effective_dt DATE) IS
48: SELECT IGS_CA_DA_INST_V.alias_val,
49: IGS_CA_DA_INST_V.ci_sequence_number
50: FROM IGS_CA_DA_INST_V,
51: IGS_CA_INST,
52: IGS_CA_STAT
53: WHERE IGS_CA_DA_INST_V.cal_type = cp_cal_type AND

Line 50: FROM IGS_CA_DA_INST_V,

46: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE,
47: cp_effective_dt DATE) IS
48: SELECT IGS_CA_DA_INST_V.alias_val,
49: IGS_CA_DA_INST_V.ci_sequence_number
50: FROM IGS_CA_DA_INST_V,
51: IGS_CA_INST,
52: IGS_CA_STAT
53: WHERE IGS_CA_DA_INST_V.cal_type = cp_cal_type AND
54: IGS_CA_DA_INST_V.dt_alias = cp_dt_alias AND

Line 53: WHERE IGS_CA_DA_INST_V.cal_type = cp_cal_type AND

49: IGS_CA_DA_INST_V.ci_sequence_number
50: FROM IGS_CA_DA_INST_V,
51: IGS_CA_INST,
52: IGS_CA_STAT
53: WHERE IGS_CA_DA_INST_V.cal_type = cp_cal_type AND
54: IGS_CA_DA_INST_V.dt_alias = cp_dt_alias AND
55: IGS_CA_DA_INST_V.alias_val <= cp_effective_dt AND
56: IGS_CA_DA_INST_V.cal_type = IGS_CA_INST.cal_type AND
57: IGS_CA_DA_INST_V.ci_sequence_number = IGS_CA_INST.sequence_number AND

Line 54: IGS_CA_DA_INST_V.dt_alias = cp_dt_alias AND

50: FROM IGS_CA_DA_INST_V,
51: IGS_CA_INST,
52: IGS_CA_STAT
53: WHERE IGS_CA_DA_INST_V.cal_type = cp_cal_type AND
54: IGS_CA_DA_INST_V.dt_alias = cp_dt_alias AND
55: IGS_CA_DA_INST_V.alias_val <= cp_effective_dt AND
56: IGS_CA_DA_INST_V.cal_type = IGS_CA_INST.cal_type AND
57: IGS_CA_DA_INST_V.ci_sequence_number = IGS_CA_INST.sequence_number AND
58: IGS_CA_STAT.cal_status = IGS_CA_INST.cal_status AND

Line 55: IGS_CA_DA_INST_V.alias_val <= cp_effective_dt AND

51: IGS_CA_INST,
52: IGS_CA_STAT
53: WHERE IGS_CA_DA_INST_V.cal_type = cp_cal_type AND
54: IGS_CA_DA_INST_V.dt_alias = cp_dt_alias AND
55: IGS_CA_DA_INST_V.alias_val <= cp_effective_dt AND
56: IGS_CA_DA_INST_V.cal_type = IGS_CA_INST.cal_type AND
57: IGS_CA_DA_INST_V.ci_sequence_number = IGS_CA_INST.sequence_number AND
58: IGS_CA_STAT.cal_status = IGS_CA_INST.cal_status AND
59: IGS_CA_STAT.s_cal_status <> cst_planned

Line 56: IGS_CA_DA_INST_V.cal_type = IGS_CA_INST.cal_type AND

52: IGS_CA_STAT
53: WHERE IGS_CA_DA_INST_V.cal_type = cp_cal_type AND
54: IGS_CA_DA_INST_V.dt_alias = cp_dt_alias AND
55: IGS_CA_DA_INST_V.alias_val <= cp_effective_dt AND
56: IGS_CA_DA_INST_V.cal_type = IGS_CA_INST.cal_type AND
57: IGS_CA_DA_INST_V.ci_sequence_number = IGS_CA_INST.sequence_number AND
58: IGS_CA_STAT.cal_status = IGS_CA_INST.cal_status AND
59: IGS_CA_STAT.s_cal_status <> cst_planned
60: ORDER BY alias_val DESC;

Line 57: IGS_CA_DA_INST_V.ci_sequence_number = IGS_CA_INST.sequence_number AND

53: WHERE IGS_CA_DA_INST_V.cal_type = cp_cal_type AND
54: IGS_CA_DA_INST_V.dt_alias = cp_dt_alias AND
55: IGS_CA_DA_INST_V.alias_val <= cp_effective_dt AND
56: IGS_CA_DA_INST_V.cal_type = IGS_CA_INST.cal_type AND
57: IGS_CA_DA_INST_V.ci_sequence_number = IGS_CA_INST.sequence_number AND
58: IGS_CA_STAT.cal_status = IGS_CA_INST.cal_status AND
59: IGS_CA_STAT.s_cal_status <> cst_planned
60: ORDER BY alias_val DESC;
61: BEGIN