APPS.IGS_PS_VAL_RCT dependencies on IGS_LOOKUPS_VIEW

Line 9: v_closed_ind IGS_LOOKUPS_VIEW.closed_ind%TYPE;

5: FUNCTION crsp_val_rct_srct(
6: p_s_reference_cd_type IN VARCHAR2 ,
7: p_message_name OUT NOCOPY VARCHAR2 )
8: RETURN BOOLEAN AS
9: v_closed_ind IGS_LOOKUPS_VIEW.closed_ind%TYPE;
10: CURSOR c_ref_cd_type_closed_ind IS
11: SELECT closed_ind
12: FROM IGS_LOOKUPS_VIEW
13: WHERE Lookup_code = p_s_reference_cd_type

Line 12: FROM IGS_LOOKUPS_VIEW

8: RETURN BOOLEAN AS
9: v_closed_ind IGS_LOOKUPS_VIEW.closed_ind%TYPE;
10: CURSOR c_ref_cd_type_closed_ind IS
11: SELECT closed_ind
12: FROM IGS_LOOKUPS_VIEW
13: WHERE Lookup_code = p_s_reference_cd_type
14: AND Lookup_type = 'REFERENCE_CD_TYPE'
15: AND closed_ind = 'Y';
16: BEGIN