APPS.IGS_GR_VAL_GHL dependencies on IGS_GR_HONOURS_LEVEL

Line 53: v_hl IGS_GR_HONOURS_LEVEL.govt_honours_level%TYPE;

49: BEGIN -- grdp_val_ghl_upd
50: -- This module validates that there are no open user defined honours level
51: -- records mapped to this government honours level.
52: DECLARE
53: v_hl IGS_GR_HONOURS_LEVEL.govt_honours_level%TYPE;
54: CURSOR c_hl IS
55: SELECT 'x'
56: FROM IGS_GR_HONOURS_LEVEL hl
57: WHERE hl.govt_honours_level = p_govt_honours_level AND

Line 56: FROM IGS_GR_HONOURS_LEVEL hl

52: DECLARE
53: v_hl IGS_GR_HONOURS_LEVEL.govt_honours_level%TYPE;
54: CURSOR c_hl IS
55: SELECT 'x'
56: FROM IGS_GR_HONOURS_LEVEL hl
57: WHERE hl.govt_honours_level = p_govt_honours_level AND
58: hl.closed_ind = 'N';
59: BEGIN
60: -- Set the default message number