APPS.IGS_HE_CREATE_EXTRACT_PKG dependencies on IGS_HE_SYS_RT_CL_FLD

Line 150: FROM igs_he_sys_rt_cl_fld sfld,

146: CURSOR c_field_stats (cp_user_return_subclass igs_he_usr_rtn_clas.user_return_subclass%TYPE) IS
147: SELECT sfld.field_number,
148: NVL(sfld.length,0) length,
149: sfld.closed_flag
150: FROM igs_he_sys_rt_cl_fld sfld,
151: igs_he_usr_rt_cl_fld ufld,
152: igs_he_usr_rtn_clas uclas
153: WHERE uclas.user_return_subclass = cp_user_return_subclass
154: AND sfld.system_return_class_type = uclas.system_return_class_type

Line 182: l_field_length igs_he_sys_rt_cl_fld.length%TYPE;

178: l_field_stat field_stats_rec;
179: l_field_lookup field_lookup_tbl;
180: l_line_count NUMBER := 0;
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;