623: l_fte_prop_flag BOOLEAN := FALSE ;
624:
625: -- Variables for dynamic sql
626: l_prs_grp_sql VARCHAR2(32767);
627: l_group_type igs_pe_persid_group_v.group_type%TYPE;
628: l_prs_grp_status VARCHAR2(1) := NULL;
629: l_cursor_id NUMBER;
630: l_num_rows NUMBER;
631: l_fte_calc_sql VARCHAR2(32767);
1018:
1019: -- Determine type (static or dynamic) of person id group
1020: CURSOR c_group_type IS
1021: SELECT group_type
1022: FROM igs_pe_persid_group_v
1023: WHERE group_id = p_person_id_grp;
1024:
1025: BEGIN
1026: