APPS.IGS_PS_VAL_AW dependencies on IGS_GR_TESTAMUR_TYPE

Line 107: p_testamur_type IGS_GR_TESTAMUR_TYPE.testamur_type%TYPE ,

103: END crsp_val_aw_upd;
104:
105: -- Validate a testamur type is not closed.
106: FUNCTION crsp_val_tt_closed(
107: p_testamur_type IGS_GR_TESTAMUR_TYPE.testamur_type%TYPE ,
108: p_message_name OUT NOCOPY VARCHAR2)
109: RETURN BOOLEAN AS
110: BEGIN -- crsp_val_tt_closed
111: -- Validate if the testamur type is closed.

Line 115: FROM IGS_GR_TESTAMUR_TYPE tt

111: -- Validate if the testamur type is closed.
112: DECLARE
113: CURSOR c_tt IS
114: SELECT 'x'
115: FROM IGS_GR_TESTAMUR_TYPE tt
116: WHERE testamur_type = p_testamur_type AND
117: closed_ind = 'Y';
118: v_tt_exists VARCHAR2(1);
119: BEGIN