APPS.IGS_CA_INS_ROLL_CI dependencies on IGS_FI_TP_RET_SCHD

Line 63: FROM IGS_FI_TP_RET_SCHD tpret

59: AS
60: CURSOR chk_da_used_ret(cp_cal_type VARCHAR2,cp_seq_num NUMBER,cp_dt_alias VARCHAR2,cp_dt_alias_seq_num NUMBER)
61: IS
62: SELECT tpret.ret_percentage, tpret.ret_amount
63: FROM IGS_FI_TP_RET_SCHD tpret
64: WHERE teach_cal_type = cp_cal_type AND
65: teach_ci_sequence_number = cp_seq_num AND
66: dt_alias = cp_dt_alias AND
67: dai_sequence_number = cp_dt_alias_seq_num AND

Line 84: IGS_FI_TP_RET_SCHD_PKG.insert_row(x_rowid => lv_rowid,

80: IF (chk_da_used_ret%FOUND)
81: THEN
82: CLOSE chk_da_used_ret;
83: -- Call TBH to insert a record for the retention schedule for the new calendar instance.
84: IGS_FI_TP_RET_SCHD_PKG.insert_row(x_rowid => lv_rowid,
85: x_ftci_teach_retention_id => l_ftci_teach_retention_id,
86: x_teach_cal_type => p_old_ca_type,
87: x_teach_ci_sequence_number => p_new_ci_seq_num,
88: x_fee_cal_type => null,