APPS.IGS_EN_VAL_CNC dependencies on IGS_PE_GOV_COUNTRYCD

Line 14: gv_closed_ind IGS_PE_GOV_COUNTRYCD.closed_ind%TYPE;

10: RETURN BOOLEAN AS
11: BEGIN
12: DECLARE
13: gv_other_detail VARCHAR(255);
14: gv_closed_ind IGS_PE_GOV_COUNTRYCD.closed_ind%TYPE;
15: CURSOR gc_govt_country_cd(
16: cp_govt_country_cd IGS_PE_GOV_COUNTRYCD.govt_country_cd%TYPE) IS
17: SELECT IGS_PE_GOV_COUNTRYCD.closed_ind
18: FROM IGS_PE_GOV_COUNTRYCD

Line 16: cp_govt_country_cd IGS_PE_GOV_COUNTRYCD.govt_country_cd%TYPE) IS

12: DECLARE
13: gv_other_detail VARCHAR(255);
14: gv_closed_ind IGS_PE_GOV_COUNTRYCD.closed_ind%TYPE;
15: CURSOR gc_govt_country_cd(
16: cp_govt_country_cd IGS_PE_GOV_COUNTRYCD.govt_country_cd%TYPE) IS
17: SELECT IGS_PE_GOV_COUNTRYCD.closed_ind
18: FROM IGS_PE_GOV_COUNTRYCD
19: WHERE IGS_PE_GOV_COUNTRYCD.govt_country_cd = cp_govt_country_cd;
20: BEGIN

Line 17: SELECT IGS_PE_GOV_COUNTRYCD.closed_ind

13: gv_other_detail VARCHAR(255);
14: gv_closed_ind IGS_PE_GOV_COUNTRYCD.closed_ind%TYPE;
15: CURSOR gc_govt_country_cd(
16: cp_govt_country_cd IGS_PE_GOV_COUNTRYCD.govt_country_cd%TYPE) IS
17: SELECT IGS_PE_GOV_COUNTRYCD.closed_ind
18: FROM IGS_PE_GOV_COUNTRYCD
19: WHERE IGS_PE_GOV_COUNTRYCD.govt_country_cd = cp_govt_country_cd;
20: BEGIN
21: -- This module validates if IGS_PE_GOV_COUNTRYCD.govt_country_cd

Line 18: FROM IGS_PE_GOV_COUNTRYCD

14: gv_closed_ind IGS_PE_GOV_COUNTRYCD.closed_ind%TYPE;
15: CURSOR gc_govt_country_cd(
16: cp_govt_country_cd IGS_PE_GOV_COUNTRYCD.govt_country_cd%TYPE) IS
17: SELECT IGS_PE_GOV_COUNTRYCD.closed_ind
18: FROM IGS_PE_GOV_COUNTRYCD
19: WHERE IGS_PE_GOV_COUNTRYCD.govt_country_cd = cp_govt_country_cd;
20: BEGIN
21: -- This module validates if IGS_PE_GOV_COUNTRYCD.govt_country_cd
22: -- is closed

Line 19: WHERE IGS_PE_GOV_COUNTRYCD.govt_country_cd = cp_govt_country_cd;

15: CURSOR gc_govt_country_cd(
16: cp_govt_country_cd IGS_PE_GOV_COUNTRYCD.govt_country_cd%TYPE) IS
17: SELECT IGS_PE_GOV_COUNTRYCD.closed_ind
18: FROM IGS_PE_GOV_COUNTRYCD
19: WHERE IGS_PE_GOV_COUNTRYCD.govt_country_cd = cp_govt_country_cd;
20: BEGIN
21: -- This module validates if IGS_PE_GOV_COUNTRYCD.govt_country_cd
22: -- is closed
23: p_message_name := null;

Line 21: -- This module validates if IGS_PE_GOV_COUNTRYCD.govt_country_cd

17: SELECT IGS_PE_GOV_COUNTRYCD.closed_ind
18: FROM IGS_PE_GOV_COUNTRYCD
19: WHERE IGS_PE_GOV_COUNTRYCD.govt_country_cd = cp_govt_country_cd;
20: BEGIN
21: -- This module validates if IGS_PE_GOV_COUNTRYCD.govt_country_cd
22: -- is closed
23: p_message_name := null;
24: OPEN gc_govt_country_cd(
25: p_govt_country_cd);