APPS.IGS_HE_CREATE_EXTRACT_PKG dependencies on IGS_PE_PERSID_GROUP_V

Line 169: FROM igs_pe_persid_group_v

165:
166: -- Determine type (static or dynamic) of persion id group
167: CURSOR c_group_type IS
168: SELECT group_type
169: FROM igs_pe_persid_group_v
170: WHERE group_id = p_person_id_grp;
171:
172:
173: TYPE ref_extract_line IS REF CURSOR;

Line 185: l_group_type igs_pe_persid_group_v.group_type%TYPE;

181: l_final_value VARCHAR2(200);
182: l_field_length igs_he_sys_rt_cl_fld.length%TYPE;
183: l_value_field_length NUMBER(3);
184: l_prs_grp_status VARCHAR2(1) := NULL;
185: l_group_type igs_pe_persid_group_v.group_type%TYPE;
186: l_file utl_file.file_type := NULL;
187: l_sqlstmt VARCHAR2(32767);
188: l_prs_grp_sql VARCHAR2(32767);
189: l_extract_dtls c_extract_dtls%ROWTYPE;