APPS.IGS_FI_PRC_IMPCLC_ANC_CHGS dependencies on IGS_FI_F_TYP_CA_INST

Line 249: FROM igs_fi_f_typ_ca_inst ftci, igs_fi_fee_str_stat fss

245: CURSOR cur_ftci(cp_cal_type igs_fi_anc_rates.Fee_Cal_Type%TYPE,
246: cp_ci_sequence_number igs_fi_anc_rates.Fee_Ci_Sequence_Number%TYPE,
247: cp_fee_type igs_fi_anc_rates.Fee_Type%TYPE) IS
248: SELECT 'x'
249: FROM igs_fi_f_typ_ca_inst ftci, igs_fi_fee_str_stat fss
250: WHERE ftci.fee_cal_type = cp_cal_type
251: AND ftci.fee_ci_sequence_number = cp_ci_sequence_number
252: AND ftci.fee_type = cp_fee_type
253: AND fss.fee_structure_status = ftci.fee_type_ci_status

Line 492: cp_fee_cal_type IGS_FI_F_TYP_CA_INST.Fee_Cal_Type%TYPE,

488: AND api_person_id = cp_api_person_id;
489:
490: -- Cursor for checking whether the record exists in the Import Charges table
491: CURSOR cur_impchgs(cp_person_id IGS_PE_PERSON.Person_Id%TYPE,
492: cp_fee_cal_type IGS_FI_F_TYP_CA_INST.Fee_Cal_Type%TYPE,
493: cp_fee_ci_sequence_number IGS_FI_F_TYP_CA_INST.Fee_Ci_Sequence_Number%TYPE,
494: cp_fee_type IGS_FI_F_TYP_CA_INST.Fee_Type%TYPE,
495: cp_transaction_type VARCHAR2) IS
496: SELECT import_charges_id

Line 493: cp_fee_ci_sequence_number IGS_FI_F_TYP_CA_INST.Fee_Ci_Sequence_Number%TYPE,

489:
490: -- Cursor for checking whether the record exists in the Import Charges table
491: CURSOR cur_impchgs(cp_person_id IGS_PE_PERSON.Person_Id%TYPE,
492: cp_fee_cal_type IGS_FI_F_TYP_CA_INST.Fee_Cal_Type%TYPE,
493: cp_fee_ci_sequence_number IGS_FI_F_TYP_CA_INST.Fee_Ci_Sequence_Number%TYPE,
494: cp_fee_type IGS_FI_F_TYP_CA_INST.Fee_Type%TYPE,
495: cp_transaction_type VARCHAR2) IS
496: SELECT import_charges_id
497: FROM igs_fi_imp_chgs

Line 494: cp_fee_type IGS_FI_F_TYP_CA_INST.Fee_Type%TYPE,

490: -- Cursor for checking whether the record exists in the Import Charges table
491: CURSOR cur_impchgs(cp_person_id IGS_PE_PERSON.Person_Id%TYPE,
492: cp_fee_cal_type IGS_FI_F_TYP_CA_INST.Fee_Cal_Type%TYPE,
493: cp_fee_ci_sequence_number IGS_FI_F_TYP_CA_INST.Fee_Ci_Sequence_Number%TYPE,
494: cp_fee_type IGS_FI_F_TYP_CA_INST.Fee_Type%TYPE,
495: cp_transaction_type VARCHAR2) IS
496: SELECT import_charges_id
497: FROM igs_fi_imp_chgs
498: WHERE person_id = cp_person_id

Line 508: cp_fee_cal_type IGS_FI_F_TYP_CA_INST.Fee_Cal_Type%TYPE,

504: -- Cursor for summing up the values from the Invoice Interface table
505: -- Charges that were reversed or declined are not to be
506: -- considered while summing the invoice_amount values.
507: CURSOR cur_inv_int(cp_person_id IGS_PE_PERSON.Person_Id%TYPE,
508: cp_fee_cal_type IGS_FI_F_TYP_CA_INST.Fee_Cal_Type%TYPE,
509: cp_fee_ci_sequence_number IGS_FI_F_TYP_CA_INST.Fee_Ci_Sequence_Number%TYPE,
510: cp_fee_type IGS_FI_F_TYP_CA_INST.Fee_Type%TYPE,
511: cp_transaction_type VARCHAR2) IS
512: SELECT SUM(invoice_amount)

Line 509: cp_fee_ci_sequence_number IGS_FI_F_TYP_CA_INST.Fee_Ci_Sequence_Number%TYPE,

505: -- Charges that were reversed or declined are not to be
506: -- considered while summing the invoice_amount values.
507: CURSOR cur_inv_int(cp_person_id IGS_PE_PERSON.Person_Id%TYPE,
508: cp_fee_cal_type IGS_FI_F_TYP_CA_INST.Fee_Cal_Type%TYPE,
509: cp_fee_ci_sequence_number IGS_FI_F_TYP_CA_INST.Fee_Ci_Sequence_Number%TYPE,
510: cp_fee_type IGS_FI_F_TYP_CA_INST.Fee_Type%TYPE,
511: cp_transaction_type VARCHAR2) IS
512: SELECT SUM(invoice_amount)
513: FROM igs_fi_inv_int inv

Line 510: cp_fee_type IGS_FI_F_TYP_CA_INST.Fee_Type%TYPE,

506: -- considered while summing the invoice_amount values.
507: CURSOR cur_inv_int(cp_person_id IGS_PE_PERSON.Person_Id%TYPE,
508: cp_fee_cal_type IGS_FI_F_TYP_CA_INST.Fee_Cal_Type%TYPE,
509: cp_fee_ci_sequence_number IGS_FI_F_TYP_CA_INST.Fee_Ci_Sequence_Number%TYPE,
510: cp_fee_type IGS_FI_F_TYP_CA_INST.Fee_Type%TYPE,
511: cp_transaction_type VARCHAR2) IS
512: SELECT SUM(invoice_amount)
513: FROM igs_fi_inv_int inv
514: WHERE inv.person_id = cp_person_id