APPS.IGS_EN_VAL_ATC dependencies on IGS_PE_GOV_ABRGRESCD

Line 13: gv_closed_ind IGS_PE_GOV_ABRGRESCD.closed_ind%TYPE;

9: RETURN BOOLEAN AS
10: BEGIN
11: DECLARE
12: gv_other_detail VARCHAR(255);
13: gv_closed_ind IGS_PE_GOV_ABRGRESCD.closed_ind%TYPE;
14: CURSOR gc_gat_cd(
15: cp_gat_cd IGS_PE_GOV_ABRGRESCD.govt_aborig_torres_cd%TYPE) IS
16: SELECT IGS_PE_GOV_ABRGRESCD.closed_ind
17: FROM IGS_PE_GOV_ABRGRESCD

Line 15: cp_gat_cd IGS_PE_GOV_ABRGRESCD.govt_aborig_torres_cd%TYPE) IS

11: DECLARE
12: gv_other_detail VARCHAR(255);
13: gv_closed_ind IGS_PE_GOV_ABRGRESCD.closed_ind%TYPE;
14: CURSOR gc_gat_cd(
15: cp_gat_cd IGS_PE_GOV_ABRGRESCD.govt_aborig_torres_cd%TYPE) IS
16: SELECT IGS_PE_GOV_ABRGRESCD.closed_ind
17: FROM IGS_PE_GOV_ABRGRESCD
18: WHERE IGS_PE_GOV_ABRGRESCD.govt_aborig_torres_cd = cp_gat_cd;
19: BEGIN

Line 16: SELECT IGS_PE_GOV_ABRGRESCD.closed_ind

12: gv_other_detail VARCHAR(255);
13: gv_closed_ind IGS_PE_GOV_ABRGRESCD.closed_ind%TYPE;
14: CURSOR gc_gat_cd(
15: cp_gat_cd IGS_PE_GOV_ABRGRESCD.govt_aborig_torres_cd%TYPE) IS
16: SELECT IGS_PE_GOV_ABRGRESCD.closed_ind
17: FROM IGS_PE_GOV_ABRGRESCD
18: WHERE IGS_PE_GOV_ABRGRESCD.govt_aborig_torres_cd = cp_gat_cd;
19: BEGIN
20: -- This module validates if IGS_PE_GOV_ABRGRESCD.govt_aborig_torres_cd

Line 17: FROM IGS_PE_GOV_ABRGRESCD

13: gv_closed_ind IGS_PE_GOV_ABRGRESCD.closed_ind%TYPE;
14: CURSOR gc_gat_cd(
15: cp_gat_cd IGS_PE_GOV_ABRGRESCD.govt_aborig_torres_cd%TYPE) IS
16: SELECT IGS_PE_GOV_ABRGRESCD.closed_ind
17: FROM IGS_PE_GOV_ABRGRESCD
18: WHERE IGS_PE_GOV_ABRGRESCD.govt_aborig_torres_cd = cp_gat_cd;
19: BEGIN
20: -- This module validates if IGS_PE_GOV_ABRGRESCD.govt_aborig_torres_cd
21: -- is closed

Line 18: WHERE IGS_PE_GOV_ABRGRESCD.govt_aborig_torres_cd = cp_gat_cd;

14: CURSOR gc_gat_cd(
15: cp_gat_cd IGS_PE_GOV_ABRGRESCD.govt_aborig_torres_cd%TYPE) IS
16: SELECT IGS_PE_GOV_ABRGRESCD.closed_ind
17: FROM IGS_PE_GOV_ABRGRESCD
18: WHERE IGS_PE_GOV_ABRGRESCD.govt_aborig_torres_cd = cp_gat_cd;
19: BEGIN
20: -- This module validates if IGS_PE_GOV_ABRGRESCD.govt_aborig_torres_cd
21: -- is closed
22: p_message_name := null;

Line 20: -- This module validates if IGS_PE_GOV_ABRGRESCD.govt_aborig_torres_cd

16: SELECT IGS_PE_GOV_ABRGRESCD.closed_ind
17: FROM IGS_PE_GOV_ABRGRESCD
18: WHERE IGS_PE_GOV_ABRGRESCD.govt_aborig_torres_cd = cp_gat_cd;
19: BEGIN
20: -- This module validates if IGS_PE_GOV_ABRGRESCD.govt_aborig_torres_cd
21: -- is closed
22: p_message_name := null;
23: OPEN gc_gat_cd(p_govt_aborig_torres_cd);
24: FETCH gc_gat_cd INTO gv_closed_ind;