DBA Data[Home] [Help]

APPS.IGS_FI_ANC_RATES_PKG dependencies on IGS_FI_F_TYP_CA_INST_LKP_V

Line 129: cp_anc_att15 IGS_FI_ANC_RATES.ancillary_attribute15%TYPE,cp_fee_type IGS_FI_F_TYP_CA_INST_LKP_V.fee_type%TYPE,

125: cp_anc_att7 IGS_FI_ANC_RATES.ancillary_attribute7%TYPE, cp_anc_att8 IGS_FI_ANC_RATES.ancillary_attribute8%TYPE,
126: cp_anc_att9 IGS_FI_ANC_RATES.ancillary_attribute9%TYPE, cp_anc_att10 IGS_FI_ANC_RATES.ancillary_attribute10%TYPE,
127: cp_anc_att11 IGS_FI_ANC_RATES.ancillary_attribute11%TYPE,cp_anc_att12 IGS_FI_ANC_RATES.ancillary_attribute12%TYPE,
128: cp_anc_att13 IGS_FI_ANC_RATES.ancillary_attribute13%TYPE,cp_anc_att14 IGS_FI_ANC_RATES.ancillary_attribute14%TYPE,
129: cp_anc_att15 IGS_FI_ANC_RATES.ancillary_attribute15%TYPE,cp_fee_type IGS_FI_F_TYP_CA_INST_LKP_V.fee_type%TYPE,
130: cp_sequence_number IGS_FI_F_TYP_CA_INST_LKP_V.fee_ci_sequence_number%TYPE,
131: cp_fee_cal_type IGS_FI_F_TYP_CA_INST_LKP_V.fee_cal_type%TYPE,
132: cp_anc_chg_rate IGS_FI_ANC_RATES.ancillary_chg_rate%TYPE) IS
133:

Line 130: cp_sequence_number IGS_FI_F_TYP_CA_INST_LKP_V.fee_ci_sequence_number%TYPE,

126: cp_anc_att9 IGS_FI_ANC_RATES.ancillary_attribute9%TYPE, cp_anc_att10 IGS_FI_ANC_RATES.ancillary_attribute10%TYPE,
127: cp_anc_att11 IGS_FI_ANC_RATES.ancillary_attribute11%TYPE,cp_anc_att12 IGS_FI_ANC_RATES.ancillary_attribute12%TYPE,
128: cp_anc_att13 IGS_FI_ANC_RATES.ancillary_attribute13%TYPE,cp_anc_att14 IGS_FI_ANC_RATES.ancillary_attribute14%TYPE,
129: cp_anc_att15 IGS_FI_ANC_RATES.ancillary_attribute15%TYPE,cp_fee_type IGS_FI_F_TYP_CA_INST_LKP_V.fee_type%TYPE,
130: cp_sequence_number IGS_FI_F_TYP_CA_INST_LKP_V.fee_ci_sequence_number%TYPE,
131: cp_fee_cal_type IGS_FI_F_TYP_CA_INST_LKP_V.fee_cal_type%TYPE,
132: cp_anc_chg_rate IGS_FI_ANC_RATES.ancillary_chg_rate%TYPE) IS
133:
134: SELECT 'x' FROM igs_fi_impchgs_lines i

Line 131: cp_fee_cal_type IGS_FI_F_TYP_CA_INST_LKP_V.fee_cal_type%TYPE,

127: cp_anc_att11 IGS_FI_ANC_RATES.ancillary_attribute11%TYPE,cp_anc_att12 IGS_FI_ANC_RATES.ancillary_attribute12%TYPE,
128: cp_anc_att13 IGS_FI_ANC_RATES.ancillary_attribute13%TYPE,cp_anc_att14 IGS_FI_ANC_RATES.ancillary_attribute14%TYPE,
129: cp_anc_att15 IGS_FI_ANC_RATES.ancillary_attribute15%TYPE,cp_fee_type IGS_FI_F_TYP_CA_INST_LKP_V.fee_type%TYPE,
130: cp_sequence_number IGS_FI_F_TYP_CA_INST_LKP_V.fee_ci_sequence_number%TYPE,
131: cp_fee_cal_type IGS_FI_F_TYP_CA_INST_LKP_V.fee_cal_type%TYPE,
132: cp_anc_chg_rate IGS_FI_ANC_RATES.ancillary_chg_rate%TYPE) IS
133:
134: SELECT 'x' FROM igs_fi_impchgs_lines i
135: WHERE (ancillary_attribute1 = cp_anc_att1 OR ( ancillary_attribute1 IS NULL AND cp_anc_att1 IS NULL)) AND