DBA Data[Home] [Help]

APPS.IGS_HE_FTE_CALC_PKG dependencies on IGS_PE_PERSID_GROUP_V

Line 627: l_group_type igs_pe_persid_group_v.group_type%TYPE;

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);

Line 1022: FROM igs_pe_persid_group_v

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: