APPS.IGS_AD_VAL_SAFT dependencies on IGS_FI_FUND_SRC

Line 12: -- Validate if IGS_FI_FUND_SRC.funding_source is closed.

8: -------------------------------------------------------------------------------------------
9:
10:
11: --
12: -- Validate if IGS_FI_FUND_SRC.funding_source is closed.
13: FUNCTION crsp_val_fs_closed(
14: p_funding_source IN VARCHAR2 ,
15: p_message_name OUT NOCOPY VARCHAR2 )
16: RETURN BOOLEAN AS

Line 18: -- Description: Validate if IGS_FI_FUND_SRC.funding_source is closed.

14: p_funding_source IN VARCHAR2 ,
15: p_message_name OUT NOCOPY VARCHAR2 )
16: RETURN BOOLEAN AS
17: BEGIN -- crsp_val_fs_closed
18: -- Description: Validate if IGS_FI_FUND_SRC.funding_source is closed.
19: DECLARE
20: v_fs_rec IGS_FI_FUND_SRC.closed_ind%TYPE;
21: CURSOR c_fs IS
22: SELECT fs.closed_ind

Line 20: v_fs_rec IGS_FI_FUND_SRC.closed_ind%TYPE;

16: RETURN BOOLEAN AS
17: BEGIN -- crsp_val_fs_closed
18: -- Description: Validate if IGS_FI_FUND_SRC.funding_source is closed.
19: DECLARE
20: v_fs_rec IGS_FI_FUND_SRC.closed_ind%TYPE;
21: CURSOR c_fs IS
22: SELECT fs.closed_ind
23: FROM IGS_FI_FUND_SRC fs
24: WHERE fs.funding_source = p_funding_source;

Line 23: FROM IGS_FI_FUND_SRC fs

19: DECLARE
20: v_fs_rec IGS_FI_FUND_SRC.closed_ind%TYPE;
21: CURSOR c_fs IS
22: SELECT fs.closed_ind
23: FROM IGS_FI_FUND_SRC fs
24: WHERE fs.funding_source = p_funding_source;
25: BEGIN
26: p_message_name := null;
27: OPEN c_fs;