APPS.IGF_SL_REL_DISB dependencies on IGS_PE_PERSID_GROUP

Line 372: FROM igs_pe_persid_group_all

368:
369: CURSOR cur_get_grp_name(p_per_grp_id NUMBER)
370: IS
371: SELECT group_cd
372: FROM igs_pe_persid_group_all
373: WHERE GROUP_ID = p_per_grp_id;
374:
375: get_grp_name_rec cur_get_grp_name%ROWTYPE;
376:

Line 3352: p_per_grp_id igs_pe_persid_group_all.GROUP_ID%TYPE

3348:
3349: -- Cursor to retreive Persons from Person Group
3350: -- The code can handle dynamic person id groups
3351: CURSOR cur_per_grp_name(
3352: p_per_grp_id igs_pe_persid_group_all.GROUP_ID%TYPE
3353: )
3354: IS
3355: SELECT group_cd --Code of a person ID group.
3356: --A person ID group also has a unique system generated sequencenumber or group ID

Line 3357: FROM igs_pe_persid_group

3353: )
3354: IS
3355: SELECT group_cd --Code of a person ID group.
3356: --A person ID group also has a unique system generated sequencenumber or group ID
3357: FROM igs_pe_persid_group
3358: WHERE GROUP_ID = p_per_grp_id;
3359:
3360: per_grp_rec cur_per_grp_name%ROWTYPE;
3361:

Line 3395: lv_group_type igs_pe_persid_group_v.group_type%TYPE;

3391: FROM igf_aw_fund_cat_all cat, igf_aw_fund_mast_all mast
3392: WHERE mast.fund_code = cat.fund_code AND mast.fund_id = p_fund_id;
3393:
3394: get_fund_type_rec cur_get_fund_type%ROWTYPE;
3395: lv_group_type igs_pe_persid_group_v.group_type%TYPE;
3396:
3397: BEGIN
3398: p_errbuf := NULL;
3399: p_retcode := 0;