APPS.IGF_DB_SF_INTEGRATION dependencies on IGS_FI_CR_TYPES_ALL

Line 864: CURSOR cur_cr_type(cp_credit_type_id igs_fi_cr_types_all.credit_type_name%TYPE) IS

860: FROM igs_pe_person_base_v
861: WHERE person_id=cp_person_id;
862: l_cur_person cur_person%ROWTYPE;
863:
864: CURSOR cur_cr_type(cp_credit_type_id igs_fi_cr_types_all.credit_type_name%TYPE) IS
865: SELECT credit_type_name
866: FROM igs_fi_cr_types_all
867: WHERE credit_type_id = cp_credit_type_id;
868:

Line 866: FROM igs_fi_cr_types_all

862: l_cur_person cur_person%ROWTYPE;
863:
864: CURSOR cur_cr_type(cp_credit_type_id igs_fi_cr_types_all.credit_type_name%TYPE) IS
865: SELECT credit_type_name
866: FROM igs_fi_cr_types_all
867: WHERE credit_type_id = cp_credit_type_id;
868:
869: l_v_cr_type_name igs_fi_cr_types_all.credit_type_name%TYPE;
870:

Line 869: l_v_cr_type_name igs_fi_cr_types_all.credit_type_name%TYPE;

865: SELECT credit_type_name
866: FROM igs_fi_cr_types_all
867: WHERE credit_type_id = cp_credit_type_id;
868:
869: l_v_cr_type_name igs_fi_cr_types_all.credit_type_name%TYPE;
870:
871: CURSOR cur_awd(cp_award_id igf_aw_award.award_id%TYPE) IS
872: SELECT a.rowid,a.*
873: FROM igf_aw_award a

Line 924: l_v_credit_class igs_fi_cr_types_all.credit_class%TYPE;

920: l_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
921: l_message_name fnd_new_messages.message_name%TYPE;
922: -- End of Modification for Enh#2191470
923:
924: l_v_credit_class igs_fi_cr_types_all.credit_class%TYPE;
925: l_b_return_status BOOLEAN;
926:
927: l_v_holds_message fnd_new_messages.message_text%TYPE := NULL;
928: