APPS.IGS_AS_VAL_SCAP dependencies on IGS_AS_SPCL_CONS_OUT

Line 45: p_spcl_consideration_outcome IGS_AS_SPCL_CONS_OUT.spcl_consideration_outcome%TYPE ,

41: END assp_val_spcc_closed;
42: --
43: -- Validate special consideration outcome closed indicator.
44: FUNCTION assp_val_spco_closed(
45: p_spcl_consideration_outcome IGS_AS_SPCL_CONS_OUT.spcl_consideration_outcome%TYPE ,
46: p_message_name OUT NOCOPY VARCHAR2 )
47: RETURN BOOLEAN IS
48: gv_other_detail VARCHAR2(255);
49: BEGIN -- assp_val_spco_closed

Line 57: v_closed_ind IGS_AS_SPCL_CONS_OUT.closed_ind%TYPE;

53: -- the same table as special consideration outcomes (ie; the actual outcome of
54: -- an application) and are simply a subset of the special consideration
55: -- outcomes.
56: DECLARE
57: v_closed_ind IGS_AS_SPCL_CONS_OUT.closed_ind%TYPE;
58: CURSOR c_spco IS
59: SELECT closed_ind
60: FROM IGS_AS_SPCL_CONS_OUT
61: WHERE spcl_consideration_outcome = p_spcl_consideration_outcome;

Line 60: FROM IGS_AS_SPCL_CONS_OUT

56: DECLARE
57: v_closed_ind IGS_AS_SPCL_CONS_OUT.closed_ind%TYPE;
58: CURSOR c_spco IS
59: SELECT closed_ind
60: FROM IGS_AS_SPCL_CONS_OUT
61: WHERE spcl_consideration_outcome = p_spcl_consideration_outcome;
62: BEGIN
63: -- Set the default message number
64: p_message_name := null;