APPS.IGS_FI_VAL_FAR dependencies on IGS_FI_GOVT_HEC_CNTB

Line 805: -- Validate if IGS_FI_GOVT_HEC_CNTB.govt_hecs_contrbn_band is closed.

801: RETURN TRUE;
802: END;
803: END enrp_val_am_closed;
804: --
805: -- Validate if IGS_FI_GOVT_HEC_CNTB.govt_hecs_contrbn_band is closed.
806: FUNCTION finp_val_ghc_closed(
807: p_govt_hecs_cntrbtn_band IN NUMBER ,
808: p_message_name OUT NOCOPY VARCHAR2 )
809: RETURN BOOLEAN AS

Line 812: -- Validate if IGS_FI_GOVT_HEC_CNTB.govt_hecs_cntrbtn_band is closed.

808: p_message_name OUT NOCOPY VARCHAR2 )
809: RETURN BOOLEAN AS
810: gv_other_detail VARCHAR2(255);
811: BEGIN -- finp_val_ghc_closed
812: -- Validate if IGS_FI_GOVT_HEC_CNTB.govt_hecs_cntrbtn_band is closed.
813: DECLARE
814: CURSOR c_ghc(
815: cp_govt_hecs_cntrbtn_band
816: IGS_FI_GOVT_HEC_CNTB.govt_hecs_cntrbtn_band%TYPE) IS

Line 816: IGS_FI_GOVT_HEC_CNTB.govt_hecs_cntrbtn_band%TYPE) IS

812: -- Validate if IGS_FI_GOVT_HEC_CNTB.govt_hecs_cntrbtn_band is closed.
813: DECLARE
814: CURSOR c_ghc(
815: cp_govt_hecs_cntrbtn_band
816: IGS_FI_GOVT_HEC_CNTB.govt_hecs_cntrbtn_band%TYPE) IS
817: SELECT closed_ind
818: FROM IGS_FI_GOVT_HEC_CNTB
819: WHERE govt_hecs_cntrbtn_band = cp_govt_hecs_cntrbtn_band;
820: v_ghc_rec c_ghc%ROWTYPE;

Line 818: FROM IGS_FI_GOVT_HEC_CNTB

814: CURSOR c_ghc(
815: cp_govt_hecs_cntrbtn_band
816: IGS_FI_GOVT_HEC_CNTB.govt_hecs_cntrbtn_band%TYPE) IS
817: SELECT closed_ind
818: FROM IGS_FI_GOVT_HEC_CNTB
819: WHERE govt_hecs_cntrbtn_band = cp_govt_hecs_cntrbtn_band;
820: v_ghc_rec c_ghc%ROWTYPE;
821: cst_yes CONSTANT CHAR := 'Y';
822: BEGIN