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_006 dependencies on IGS_CA_DA_INST

Line 312: cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,

308: CI.sequence_number,
309: 'N') = 'Y')
310: ORDER BY CI.start_dt asc;
311: CURSOR c_dai_v(
312: cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
313: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,
314: cp_load_effect_dt_alias IGS_EN_CAL_CONF.load_effect_dt_alias%TYPE) IS
315: SELECT DAIV.alias_val
316: FROM IGS_CA_DA_INST_V DAIV

Line 313: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,

309: 'N') = 'Y')
310: ORDER BY CI.start_dt asc;
311: CURSOR c_dai_v(
312: cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
313: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,
314: cp_load_effect_dt_alias IGS_EN_CAL_CONF.load_effect_dt_alias%TYPE) IS
315: SELECT DAIV.alias_val
316: FROM IGS_CA_DA_INST_V DAIV
317: WHERE DAIV.cal_type = cp_cal_type AND

Line 316: FROM IGS_CA_DA_INST_V DAIV

312: cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
313: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,
314: cp_load_effect_dt_alias IGS_EN_CAL_CONF.load_effect_dt_alias%TYPE) IS
315: SELECT DAIV.alias_val
316: FROM IGS_CA_DA_INST_V DAIV
317: WHERE DAIV.cal_type = cp_cal_type AND
318: DAIV.ci_sequence_number = cp_ci_sequence_number AND
319: DAIV.dt_alias = cp_load_effect_dt_alias;
320: v_other_detail VARCHAR(255);

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

454: IGS_EN_SU_ATTEMPT.cal_type = IGS_CA_INST.cal_type AND
455: IGS_EN_SU_ATTEMPT.ci_sequence_number = IGS_CA_INST.sequence_number
456: ORDER BY IGS_CA_INST.start_dt;
457:
458: CURSOR c_dai_v(cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
459: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,
460: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE) IS
461: SELECT IGS_CA_GEN_001.calp_set_alias_value
462: (

Line 459: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,

455: IGS_EN_SU_ATTEMPT.ci_sequence_number = IGS_CA_INST.sequence_number
456: ORDER BY IGS_CA_INST.start_dt;
457:
458: CURSOR c_dai_v(cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
459: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,
460: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE) IS
461: SELECT IGS_CA_GEN_001.calp_set_alias_value
462: (
463: absolute_val,

Line 460: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE) IS

456: ORDER BY IGS_CA_INST.start_dt;
457:
458: CURSOR c_dai_v(cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
459: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,
460: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE) IS
461: SELECT IGS_CA_GEN_001.calp_set_alias_value
462: (
463: absolute_val,
464: IGS_CA_GEN_002.cals_clc_dt_from_dai

Line 472: FROM IGS_CA_DA_INST

468: DT_ALIAS,
469: sequence_number
470: )
471: ) alias_val
472: FROM IGS_CA_DA_INST
473: WHERE cal_type = cp_cal_type AND
474: ci_sequence_number = cp_ci_sequence_number AND
475: dt_alias = cp_dt_alias
476: ORDER BY alias_val;

Line 665: cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,

661: ci.cal_type = cat.cal_type AND
662: ci.cal_status = cs.cal_status AND
663: cs.s_cal_status = cst_active;
664: CURSOR c_daiv(
665: cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
666: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,
667: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE) IS
668:
669: SELECT IGS_CA_GEN_001.calp_set_alias_value

Line 666: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,

662: ci.cal_status = cs.cal_status AND
663: cs.s_cal_status = cst_active;
664: CURSOR c_daiv(
665: cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
666: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,
667: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE) IS
668:
669: SELECT IGS_CA_GEN_001.calp_set_alias_value
670: (

Line 667: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE) IS

663: cs.s_cal_status = cst_active;
664: CURSOR c_daiv(
665: cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
666: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,
667: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE) IS
668:
669: SELECT IGS_CA_GEN_001.calp_set_alias_value
670: (
671: absolute_val,

Line 680: FROM IGS_CA_DA_INST dai

676: DT_ALIAS,
677: sequence_number
678: )
679: ) alias_val
680: FROM IGS_CA_DA_INST dai
681: WHERE dai.cal_type = cp_cal_type AND
682: dai.ci_sequence_number = cp_ci_sequence_number AND
683: dai.dt_alias = cp_dt_alias;
684:

Line 1283: IGS_CA_DA_INST_V daiv

1279: FROM sys.dual
1280: WHERE EXISTS (
1281: SELECT 'x'
1282: FROM IGS_EN_CAL_CONF secc,
1283: IGS_CA_DA_INST_V daiv
1284: WHERE secc.s_control_num = 1 AND
1285: secc.enr_form_due_dt_alias IS NOT NULL AND
1286: daiv.cal_type = cp_cal_type AND
1287: daiv.ci_sequence_number = cp_ci_sequence_number AND