APPS.IGS_FI_PRC_REFUNDS dependencies on HZ_PARTIES

Line 696: FROM hz_parties

692: -- processed
693: -- Bug 5018036 - Cursor cur_party broken into cur_party and cur_party_all.
694: CURSOR cur_party(cp_person_id igs_fi_parties_v.person_id%TYPE) IS
695: SELECT party_id person_id
696: FROM hz_parties
697: WHERE party_id = cp_person_id;
698:
699: -- Cursor for getting the Person Ids for which the Refunds have to be
700: -- processed if no person id given

Line 804: l_n_party_id hz_parties.party_id%TYPE;

800: l_group_cd igs_pe_all_persid_group_v.group_cd%TYPE;
801: l_v_message_name fnd_new_messages.message_name%TYPE;
802: l_v_closing_status gl_period_statuses.closing_status%TYPE;
803: l_d_gl_date igs_fi_credits_all.gl_date%TYPE;
804: l_n_party_id hz_parties.party_id%TYPE;
805: l_v_manage_acc igs_fi_control_all.manage_accounts%TYPE := NULL;
806:
807: -- Variables holding number type data
808: l_n_cntr NUMBER(15) := 0;

Line 839: TYPE tab_party_rec IS TABLE OF hz_parties.party_id%TYPE INDEX BY BINARY_INTEGER;

835: -- cursor variable for cursor c_refund_cr_glccid
836: rec_c_refund_cr_glccid c_refund_cr_glccid%ROWTYPE;
837:
838: TYPE r_c_grp_cur IS REF CURSOR ;
839: TYPE tab_party_rec IS TABLE OF hz_parties.party_id%TYPE INDEX BY BINARY_INTEGER;
840: c_ref_grp_cur r_c_grp_cur;
841: v_tab_party_rec tab_party_rec ;
842:
843: l_n_act_plan_id igs_fi_pp_std_attrs.student_plan_id%TYPE;