APPS.IGF_DB_DISB dependencies on IGS_PE_PERSID_GROUP

Line 176: FROM igs_pe_persid_group_all

172:
173: CURSOR cur_get_grp_name (p_per_grp_id NUMBER)
174: IS
175: SELECT group_cd
176: FROM igs_pe_persid_group_all
177: WHERE group_id = p_per_grp_id;
178:
179: get_grp_name_rec cur_get_grp_name%ROWTYPE;
180:

Line 3640: p_per_grp_id igs_pe_persid_group_all.group_id%TYPE

3636: l_award_det c_award_det%ROWTYPE;
3637:
3638: -- Cursor to retreive Persons from Person Group
3639: CURSOR cur_per_grp_name(
3640: p_per_grp_id igs_pe_persid_group_all.group_id%TYPE
3641: ) IS
3642: SELECT group_cd
3643: FROM igs_pe_persid_group
3644: WHERE group_id = p_per_grp_id;

Line 3643: FROM igs_pe_persid_group

3639: CURSOR cur_per_grp_name(
3640: p_per_grp_id igs_pe_persid_group_all.group_id%TYPE
3641: ) IS
3642: SELECT group_cd
3643: FROM igs_pe_persid_group
3644: WHERE group_id = p_per_grp_id;
3645: per_grp_rec cur_per_grp_name%ROWTYPE;
3646:
3647: -- Cursor to retreive Student having awards for a given fund

Line 3676: lv_group_type igs_pe_persid_group_v.group_type%TYPE;

3672: cur_per_grp cur_person_id_type;
3673:
3674: l_person_id hz_parties.party_id%TYPE;
3675: lv_profile_value VARCHAR2(30);
3676: lv_group_type igs_pe_persid_group_v.group_type%TYPE;
3677: BEGIN
3678:
3679: igf_aw_gen.set_org_id(NULL);
3680: errbuf := NULL;