APPS.IGS_HE_CREATE_EXTRACT_PKG dependencies on IGS_HE_USR_RTN_CLAS

Line 146: CURSOR c_field_stats (cp_user_return_subclass igs_he_usr_rtn_clas.user_return_subclass%TYPE) IS

142: AND srt.user_return_subclass = dtls.user_return_subclass
143: AND srt.return_name = dtls.return_name;
144:
145: -- Get length and closed_flag of each field in return
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,

Line 152: igs_he_usr_rtn_clas uclas

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
155: AND ufld.field_number = sfld.field_number
156: AND ufld.user_return_subclass = uclas.user_return_subclass;