APPS.IGS_HE_VERIFY_RETURN_PKG dependencies on IGS_HE_USR_RT_CL_FLD

Line 31: igs_he_usr_rt_cl_fld fld,

27: -- ordered by the first field they appear in
28: CURSOR c_assoc IS
29: SELECT MIN(ass.field_number) field, ass.association_code, ass.oss_seq, ass.hesa_seq
30: FROM igs_he_usr_rtn_clas urc,
31: igs_he_usr_rt_cl_fld fld,
32: igs_he_sys_rt_cl_ass ass
33: WHERE urc.user_return_subclass = p_user_return_subclass
34: AND fld.user_return_subclass = urc.user_return_subclass
35: AND ass.system_return_class_type = urc.system_return_class_type

Line 47: igs_he_usr_rt_cl_fld fld,

43: -- Gets all the fields affected by a given association code
44: CURSOR c_fields(cp_association_code igs_he_sys_rt_cl_ass.association_code%TYPE) IS
45: SELECT ass.field_number
46: FROM igs_he_usr_rtn_clas urc,
47: igs_he_usr_rt_cl_fld fld,
48: igs_he_sys_rt_cl_ass ass
49: WHERE urc.user_return_subclass = p_user_return_subclass
50: AND fld.user_return_subclass = urc.user_return_subclass
51: AND ass.system_return_class_type = urc.system_return_class_type