APPS.IGS_AS_VAL_SCAP dependencies on IGS_AS_SPCL_CONS_CAT

Line 7: p_spcl_consideration_cat IGS_AS_SPCL_CONS_CAT.spcl_consideration_cat%TYPE ,

3:
4: --
5: -- Validate special consideration category closed indicator.
6: FUNCTION assp_val_spcc_closed(
7: p_spcl_consideration_cat IGS_AS_SPCL_CONS_CAT.spcl_consideration_cat%TYPE ,
8: p_message_name OUT NOCOPY VARCHAR2 )
9: RETURN BOOLEAN IS
10: gv_other_detail VARCHAR2(255);
11: BEGIN -- assp_val_spcc_closed

Line 14: v_closed_ind IGS_AS_SPCL_CONS_CAT.closed_ind%TYPE;

10: gv_other_detail VARCHAR2(255);
11: BEGIN -- assp_val_spcc_closed
12: -- Validate the special consideration category closed indicator.
13: DECLARE
14: v_closed_ind IGS_AS_SPCL_CONS_CAT.closed_ind%TYPE;
15: CURSOR c_spcc IS
16: SELECT closed_ind
17: FROM IGS_AS_SPCL_CONS_CAT
18: WHERE spcl_consideration_cat = p_spcl_consideration_cat;

Line 17: FROM IGS_AS_SPCL_CONS_CAT

13: DECLARE
14: v_closed_ind IGS_AS_SPCL_CONS_CAT.closed_ind%TYPE;
15: CURSOR c_spcc IS
16: SELECT closed_ind
17: FROM IGS_AS_SPCL_CONS_CAT
18: WHERE spcl_consideration_cat = p_spcl_consideration_cat;
19: BEGIN
20: -- Set the default message number
21: p_message_name := null;