APPS.IGS_FI_PRC_ACCT_PKG dependencies on IGS_FI_F_TYP_CA_INST

Line 672: CURSOR cur_f_typ_ca_inst_lkp (cp_fee_type igs_fi_f_typ_ca_inst_lkp_v.fee_type%TYPE,

668:
669: --
670: --Get the Account Hierachy ID.
671: --
672: CURSOR cur_f_typ_ca_inst_lkp (cp_fee_type igs_fi_f_typ_ca_inst_lkp_v.fee_type%TYPE,
673: cp_fee_cal_type igs_fi_f_typ_ca_inst_lkp_v.fee_cal_type%TYPE,
674: cp_fee_ci_sequence_number igs_fi_f_typ_ca_inst_lkp_v.fee_ci_sequence_number%TYPE)
675: IS
676: SELECT acct_hier_id,

Line 673: cp_fee_cal_type igs_fi_f_typ_ca_inst_lkp_v.fee_cal_type%TYPE,

669: --
670: --Get the Account Hierachy ID.
671: --
672: CURSOR cur_f_typ_ca_inst_lkp (cp_fee_type igs_fi_f_typ_ca_inst_lkp_v.fee_type%TYPE,
673: cp_fee_cal_type igs_fi_f_typ_ca_inst_lkp_v.fee_cal_type%TYPE,
674: cp_fee_ci_sequence_number igs_fi_f_typ_ca_inst_lkp_v.fee_ci_sequence_number%TYPE)
675: IS
676: SELECT acct_hier_id,
677: rec_account_cd,

Line 674: cp_fee_ci_sequence_number igs_fi_f_typ_ca_inst_lkp_v.fee_ci_sequence_number%TYPE)

670: --Get the Account Hierachy ID.
671: --
672: CURSOR cur_f_typ_ca_inst_lkp (cp_fee_type igs_fi_f_typ_ca_inst_lkp_v.fee_type%TYPE,
673: cp_fee_cal_type igs_fi_f_typ_ca_inst_lkp_v.fee_cal_type%TYPE,
674: cp_fee_ci_sequence_number igs_fi_f_typ_ca_inst_lkp_v.fee_ci_sequence_number%TYPE)
675: IS
676: SELECT acct_hier_id,
677: rec_account_cd,
678: rec_gl_ccid,

Line 682: FROM igs_fi_f_typ_ca_inst

678: rec_gl_ccid,
679: rev_account_cd,
680: ret_gl_ccid,
681: ret_account_cd
682: FROM igs_fi_f_typ_ca_inst
683: WHERE fee_type = cp_fee_type
684: AND fee_cal_type = cp_fee_cal_type
685: AND fee_ci_sequence_number = cp_fee_ci_sequence_number;
686: