APPS.IGS_AS_VAL_ATYP dependencies on IGS_AS_SASSESS_TYPE

Line 6: p_s_assessment_type IN IGS_AS_SASSESS_TYPE.s_assessment_type%TYPE ,

2: /* $Header: IGSAS15B.pls 115.4 2002/11/28 22:43:10 nsidana ship $ */
3: --
4: -- Validate system assessment type closed indicator
5: FUNCTION assp_val_sat_closed(
6: p_s_assessment_type IN IGS_AS_SASSESS_TYPE.s_assessment_type%TYPE ,
7: P_MESSAGE_NAME OUT NOCOPY VARCHAR2 )
8: RETURN BOOLEAN AS
9:
10: BEGIN -- assp_val_sat_closed

Line 14: cp_s_assessment_type IGS_AS_SASSESS_TYPE.s_assessment_type%TYPE) IS

10: BEGIN -- assp_val_sat_closed
11: -- Validate the System Assessment Type closed indicator
12: DECLARE
13: CURSOR c_sat(
14: cp_s_assessment_type IGS_AS_SASSESS_TYPE.s_assessment_type%TYPE) IS
15: SELECT closed_ind
16: FROM IGS_AS_SASSESS_TYPE
17: WHERE s_assessment_type = cp_s_assessment_type ;
18: v_sat_rec c_sat%ROWTYPE;

Line 16: FROM IGS_AS_SASSESS_TYPE

12: DECLARE
13: CURSOR c_sat(
14: cp_s_assessment_type IGS_AS_SASSESS_TYPE.s_assessment_type%TYPE) IS
15: SELECT closed_ind
16: FROM IGS_AS_SASSESS_TYPE
17: WHERE s_assessment_type = cp_s_assessment_type ;
18: v_sat_rec c_sat%ROWTYPE;
19: cst_yes CONSTANT CHAR := 'Y';
20: BEGIN