264: FROM igs_fi_hier_acct_tbl
265: WHERE acct_hier_id = cp_acct_hier_id
266: AND entity_type_code IN ('FTCI','SA');
267:
268: l_v_fee_type igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_TYPE');
269: l_v_fee_period igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_PERIOD');
270: l_v_acct_hierarchy igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','ACCT_HIERARCHY');
271: l_v_message_text igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','MESSAGE_TEXT');
272:
265: WHERE acct_hier_id = cp_acct_hier_id
266: AND entity_type_code IN ('FTCI','SA');
267:
268: l_v_fee_type igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_TYPE');
269: l_v_fee_period igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_PERIOD');
270: l_v_acct_hierarchy igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','ACCT_HIERARCHY');
271: l_v_message_text igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','MESSAGE_TEXT');
272:
273: l_v_rev_account_cd igs_fi_f_typ_ca_inst.rev_account_cd%TYPE;
266: AND entity_type_code IN ('FTCI','SA');
267:
268: l_v_fee_type igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_TYPE');
269: l_v_fee_period igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_PERIOD');
270: l_v_acct_hierarchy igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','ACCT_HIERARCHY');
271: l_v_message_text igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','MESSAGE_TEXT');
272:
273: l_v_rev_account_cd igs_fi_f_typ_ca_inst.rev_account_cd%TYPE;
274: l_v_entity_code igs_fi_hier_acct_tbl.entity_type_code%TYPE;
267:
268: l_v_fee_type igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_TYPE');
269: l_v_fee_period igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_PERIOD');
270: l_v_acct_hierarchy igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','ACCT_HIERARCHY');
271: l_v_message_text igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','MESSAGE_TEXT');
272:
273: l_v_rev_account_cd igs_fi_f_typ_ca_inst.rev_account_cd%TYPE;
274: l_v_entity_code igs_fi_hier_acct_tbl.entity_type_code%TYPE;
275: