DBA Data[Home] [Help]

APPS.IGF_GR_RFMS_ORIG dependencies on IGS_PE_PERSID_GROUP_ALL

Line 1443: CURSOR cur_person_group(cp_persid_grp igs_pe_persid_group_all.group_id%TYPE) IS

1439: --
1440: --------------------------------------------------------------------------
1441:
1442: -- To get group description for group_id
1443: CURSOR cur_person_group(cp_persid_grp igs_pe_persid_group_all.group_id%TYPE) IS
1444: SELECT group_cd group_name
1445: FROM igs_pe_persid_group_all
1446: WHERE group_id = cp_persid_grp;
1447: rec_person_group cur_person_group%ROWTYPE;

Line 1445: FROM igs_pe_persid_group_all

1441:
1442: -- To get group description for group_id
1443: CURSOR cur_person_group(cp_persid_grp igs_pe_persid_group_all.group_id%TYPE) IS
1444: SELECT group_cd group_name
1445: FROM igs_pe_persid_group_all
1446: WHERE group_id = cp_persid_grp;
1447: rec_person_group cur_person_group%ROWTYPE;
1448:
1449: l_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE;