DBA Data[Home] [Help]

APPS.IGS_PS_VAL_ATT dependencies on IGS_PS_GOVT_ATD_TYPE

Line 9: v_closed_ind IGS_PS_GOVT_ATD_TYPE.closed_ind%TYPE;

5: FUNCTION CRSP_VAL_ATT_GOVT(
6: p_govt_attendance_type IN VARCHAR2 ,
7: p_message_name OUT NOCOPY VARCHAR2 )
8: RETURN BOOLEAN AS
9: v_closed_ind IGS_PS_GOVT_ATD_TYPE.closed_ind%TYPE;
10: CURSOR c_govt_attendance_type(
11: cp_govt_attendance_type IGS_PS_GOVT_ATD_TYPE.govt_attendance_type%TYPE)IS
12: SELECT closed_ind
13: FROM IGS_PS_GOVT_ATD_TYPE

Line 11: cp_govt_attendance_type IGS_PS_GOVT_ATD_TYPE.govt_attendance_type%TYPE)IS

7: p_message_name OUT NOCOPY VARCHAR2 )
8: RETURN BOOLEAN AS
9: v_closed_ind IGS_PS_GOVT_ATD_TYPE.closed_ind%TYPE;
10: CURSOR c_govt_attendance_type(
11: cp_govt_attendance_type IGS_PS_GOVT_ATD_TYPE.govt_attendance_type%TYPE)IS
12: SELECT closed_ind
13: FROM IGS_PS_GOVT_ATD_TYPE
14: WHERE govt_attendance_type = cp_govt_attendance_type;
15: BEGIN

Line 13: FROM IGS_PS_GOVT_ATD_TYPE

9: v_closed_ind IGS_PS_GOVT_ATD_TYPE.closed_ind%TYPE;
10: CURSOR c_govt_attendance_type(
11: cp_govt_attendance_type IGS_PS_GOVT_ATD_TYPE.govt_attendance_type%TYPE)IS
12: SELECT closed_ind
13: FROM IGS_PS_GOVT_ATD_TYPE
14: WHERE govt_attendance_type = cp_govt_attendance_type;
15: BEGIN
16: p_message_name := NULL;
17: OPEN c_govt_attendance_type(