eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_HE_VERIFY_RETURN_PKG dependencies on IGS_HE_CODE_ASS_VAL

Line 58: CURSOR c_assoc_type(cp_association_code igs_he_code_ass_val.association_code%TYPE,

54: AND ass.association_code = cp_association_code
55: ORDER BY ass.field_number;
56:
57: -- Get the association type of the code (either CODE, DIRECT or INDIRECT)
58: CURSOR c_assoc_type(cp_association_code igs_he_code_ass_val.association_code%TYPE,
59: cp_sequence igs_he_code_ass_val.sequence%TYPE) IS
60: SELECT association_type, main_source, secondary_source, condition, display_title
61: FROM igs_he_code_ass_val
62: WHERE association_code = cp_association_code

Line 59: cp_sequence igs_he_code_ass_val.sequence%TYPE) IS

55: ORDER BY ass.field_number;
56:
57: -- Get the association type of the code (either CODE, DIRECT or INDIRECT)
58: CURSOR c_assoc_type(cp_association_code igs_he_code_ass_val.association_code%TYPE,
59: cp_sequence igs_he_code_ass_val.sequence%TYPE) IS
60: SELECT association_type, main_source, secondary_source, condition, display_title
61: FROM igs_he_code_ass_val
62: WHERE association_code = cp_association_code
63: AND sequence = cp_sequence;

Line 61: FROM igs_he_code_ass_val

57: -- Get the association type of the code (either CODE, DIRECT or INDIRECT)
58: CURSOR c_assoc_type(cp_association_code igs_he_code_ass_val.association_code%TYPE,
59: cp_sequence igs_he_code_ass_val.sequence%TYPE) IS
60: SELECT association_type, main_source, secondary_source, condition, display_title
61: FROM igs_he_code_ass_val
62: WHERE association_code = cp_association_code
63: AND sequence = cp_sequence;
64:
65: l_unmapped_value igs_he_code_map_val.map2%TYPE;