APPS.IGS_FI_PRC_FIN_LT_CHG dependencies on IGS_FI_F_TYP_CA_INST_LKP_V

Line 207: -- bug 5018036: Changed igs_fi_f_typ_ca_inst_lkp_v to igs_fi_f_typ_ca_inst_all

203: cp_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
204: cp_fee_ci_sequence_number igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE) IS
205: SELECT 'X'
206: FROM igs_fi_f_typ_ca_inst_all fcc,
207: -- bug 5018036: Changed igs_fi_f_typ_ca_inst_lkp_v to igs_fi_f_typ_ca_inst_all
208: igs_fi_fee_str_stat fss
209: WHERE fcc.fee_type = cp_fee_type
210: AND fcc.fee_cal_type = cp_fee_cal_type
211: AND fcc.fee_ci_sequence_number = cp_fee_ci_sequence_number

Line 330: p_cal_type igs_fi_f_typ_ca_inst_lkp_v.fee_cal_type%TYPE ,

326:
327:
328:
329: PROCEDURE log_plan_info(p_cur_plan cur_plan%ROWTYPE, p_batch_cutoff_dt DATE,p_batch_due_date DATE,
330: p_cal_type igs_fi_f_typ_ca_inst_lkp_v.fee_cal_type%TYPE ,
331: p_sequence_number igs_fi_f_typ_ca_inst_lkp_v.fee_ci_sequence_number%TYPE,
332: p_batch_due_dt DATE )
333: AS
334: /***********************************************************************************************

Line 331: p_sequence_number igs_fi_f_typ_ca_inst_lkp_v.fee_ci_sequence_number%TYPE,

327:
328:
329: PROCEDURE log_plan_info(p_cur_plan cur_plan%ROWTYPE, p_batch_cutoff_dt DATE,p_batch_due_date DATE,
330: p_cal_type igs_fi_f_typ_ca_inst_lkp_v.fee_cal_type%TYPE ,
331: p_sequence_number igs_fi_f_typ_ca_inst_lkp_v.fee_ci_sequence_number%TYPE,
332: p_batch_due_dt DATE )
333: AS
334: /***********************************************************************************************
335:

Line 1466: It was earlier using igs_fi_f_typ_ca_inst_lkp_v.

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
1470: Changed code related to p_test_flag to check for Y and N instead of 1 and 2 respectively.

Line 1515: l_cal_type igs_fi_f_typ_ca_inst_lkp_v.fee_cal_type%TYPE;

1511: l_offset_date DATE;
1512: l_batch_cutoff_dt DATE;
1513: l_batch_due_dt DATE;
1514: l_chg_crtn_dt DATE;
1515: l_cal_type igs_fi_f_typ_ca_inst_lkp_v.fee_cal_type%TYPE;
1516: l_sequence_number igs_fi_f_typ_ca_inst_lkp_v.fee_ci_sequence_number%TYPE;
1517: l_record_count NUMBER :=0;
1518: --Added the following as part of Enh# 2562745.
1519: l_conv_process_run_ind igs_fi_control.conv_process_run_ind%TYPE;

Line 1516: l_sequence_number igs_fi_f_typ_ca_inst_lkp_v.fee_ci_sequence_number%TYPE;

1512: l_batch_cutoff_dt DATE;
1513: l_batch_due_dt DATE;
1514: l_chg_crtn_dt DATE;
1515: l_cal_type igs_fi_f_typ_ca_inst_lkp_v.fee_cal_type%TYPE;
1516: l_sequence_number igs_fi_f_typ_ca_inst_lkp_v.fee_ci_sequence_number%TYPE;
1517: l_record_count NUMBER :=0;
1518: --Added the following as part of Enh# 2562745.
1519: l_conv_process_run_ind igs_fi_control.conv_process_run_ind%TYPE;
1520: l_message_name fnd_new_messages.message_name%TYPE;