DBA Data[Home] [Help]

APPS.IGS_FI_VAL_FTCI dependencies on IGS_CA_DA_INST_V

Line 254: v_start_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;

250: RETURN BOOLEAN AS
251: gv_other_detail VARCHAR2(255);
252: BEGIN
253: DECLARE
254: v_start_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
255: v_end_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
256: v_retro_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
257: CURSOR c_daiv (
258: cp_dt_alias IGS_CA_DA_INST_V.DT_ALIAS%TYPE,

Line 255: v_end_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;

251: gv_other_detail VARCHAR2(255);
252: BEGIN
253: DECLARE
254: v_start_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
255: v_end_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
256: v_retro_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
257: CURSOR c_daiv (
258: cp_dt_alias IGS_CA_DA_INST_V.DT_ALIAS%TYPE,
259: cp_dai_sequence_number IGS_CA_DA_INST_V.sequence_number%TYPE) IS

Line 256: v_retro_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;

252: BEGIN
253: DECLARE
254: v_start_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
255: v_end_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
256: v_retro_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
257: CURSOR c_daiv (
258: cp_dt_alias IGS_CA_DA_INST_V.DT_ALIAS%TYPE,
259: cp_dai_sequence_number IGS_CA_DA_INST_V.sequence_number%TYPE) IS
260: SELECT daiv.alias_val

Line 258: cp_dt_alias IGS_CA_DA_INST_V.DT_ALIAS%TYPE,

254: v_start_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
255: v_end_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
256: v_retro_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
257: CURSOR c_daiv (
258: cp_dt_alias IGS_CA_DA_INST_V.DT_ALIAS%TYPE,
259: cp_dai_sequence_number IGS_CA_DA_INST_V.sequence_number%TYPE) IS
260: SELECT daiv.alias_val
261: FROM IGS_CA_DA_INST_V daiv
262: WHERE daiv.CAL_TYPE = p_fee_cal_type AND

Line 259: cp_dai_sequence_number IGS_CA_DA_INST_V.sequence_number%TYPE) IS

255: v_end_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
256: v_retro_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
257: CURSOR c_daiv (
258: cp_dt_alias IGS_CA_DA_INST_V.DT_ALIAS%TYPE,
259: cp_dai_sequence_number IGS_CA_DA_INST_V.sequence_number%TYPE) IS
260: SELECT daiv.alias_val
261: FROM IGS_CA_DA_INST_V daiv
262: WHERE daiv.CAL_TYPE = p_fee_cal_type AND
263: daiv.ci_sequence_number = p_fee_ci_sequence_number AND

Line 261: FROM IGS_CA_DA_INST_V daiv

257: CURSOR c_daiv (
258: cp_dt_alias IGS_CA_DA_INST_V.DT_ALIAS%TYPE,
259: cp_dai_sequence_number IGS_CA_DA_INST_V.sequence_number%TYPE) IS
260: SELECT daiv.alias_val
261: FROM IGS_CA_DA_INST_V daiv
262: WHERE daiv.CAL_TYPE = p_fee_cal_type AND
263: daiv.ci_sequence_number = p_fee_ci_sequence_number AND
264: daiv.DT_ALIAS = cp_dt_alias AND
265: daiv.sequence_number = cp_dai_sequence_number;