APPS.IGS_CA_GEN_002 dependencies on IGS_CA_DA_INST_V

Line 1028: v_dt_alias_instance_rec IGS_CA_DA_INST_V%ROWTYPE;

1024: RETURN DATE AS
1025: v_other_detail VARCHAR(255);
1026: v_alias_value DATE;
1027: v_dt_alias_offset_rec IGS_CA_DA_OFST%ROWTYPE;
1028: v_dt_alias_instance_rec IGS_CA_DA_INST_V%ROWTYPE;
1029: v_date_offset DATE := NULL;
1030: CURSOR c_dt_alias_offset
1031: IS
1032: SELECT *

Line 1038: FROM IGS_CA_DA_INST_V

1034: WHERE DT_ALIAS = p_dt_alias;
1035: CURSOR c_dt_alias_instance
1036: IS
1037: SELECT *
1038: FROM IGS_CA_DA_INST_V
1039: WHERE DT_ALIAS = v_dt_alias_offset_rec.offset_dt_alias and
1040: CAL_TYPE = p_cal_type and
1041: ci_sequence_number = p_ci_sequence_number
1042: ORDER BY alias_val ASC;