DBA Data[Home] [Help]

APPS.IGS_FI_PRC_FIN_LT_CHG dependencies on IGS_CA_INST

Line 1465: sapanigr 13-Feb-2006 Bug 5018036 - Modified cur_fee to reference base table igs_fi_f_typ_ca_inst_all and igs_ca_inst ci.

1461:
1462: Known limitations,enhancements,remarks:
1463: Change History
1464: Who When What
1465: sapanigr 13-Feb-2006 Bug 5018036 - Modified cur_fee to reference base table igs_fi_f_typ_ca_inst_all and igs_ca_inst ci.
1466: It was earlier using igs_fi_f_typ_ca_inst_lkp_v.
1467: pmarada 01-sep-04 bug 3687308 - Enforcing user to pass either person id or personid group
1468: pathipat 26-Apr-2004 Bug 3578249 - Modified cursor cur_yes_no - Replaced fnd_lookup_values
1469: with igs_lookup_values, changed lookup_type to YES_NO from SYS_YES_NO

Line 1494: FROM igs_fi_f_typ_ca_inst_all ftci, igs_ca_inst ci

1490: CURSOR cur_fee(cp_fee_type igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
1491: cp_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
1492: cp_fee_ci_sequence_number igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE) IS
1493: SELECT ci.start_dt start_dt,ci.end_dt end_dt
1494: FROM igs_fi_f_typ_ca_inst_all ftci, igs_ca_inst ci
1495: WHERE ftci.fee_type=cp_fee_type
1496: AND ftci.fee_cal_type=cp_fee_cal_type
1497: AND ftci.fee_ci_sequence_number=cp_fee_ci_sequence_number
1498: AND ci.cal_type = ftci.fee_cal_type