320:
321: -- Determine type (static or dynamic) of persion id group
322: CURSOR c_group_type (p_group_cd VARCHAR2) IS
323: SELECT group_id, group_type
324: FROM igs_pe_persid_group_v
325: WHERE group_cd = p_group_cd;
326:
327: l_person_id NUMBER;
328: l_group_id NUMBER;
325: WHERE group_cd = p_group_cd;
326:
327: l_person_id NUMBER;
328: l_group_id NUMBER;
329: l_group_type igs_pe_persid_group_v.group_type%TYPE;
330: l_psn_group_cd igs_pe_persid_group.group_cd%TYPE := NULL;
331:
332: BEGIN
333: