APPS.IGS_EN_VAL_CNC dependencies on IGS_PE_COUNTRY_CD

Line 56: cp_country_cd IGS_PE_COUNTRY_CD.country_cd%TYPE) IS

52: DECLARE
53: v_person_id IGS_PE_PERSON.person_id%TYPE;
54: v_other_detail VARCHAR(255);
55: CURSOR gc_person_statistics(
56: cp_country_cd IGS_PE_COUNTRY_CD.country_cd%TYPE) IS
57: SELECT person_id
58: FROM IGS_PE_STATISTICS
59: WHERE NVL(birth_country_cd, 'NULL') = cp_country_cd OR
60: NVL(term_location_country, 'NULL') = cp_country_cd OR

Line 63: -- validate the deletion of IGS_PE_COUNTRY_CD record

59: WHERE NVL(birth_country_cd, 'NULL') = cp_country_cd OR
60: NVL(term_location_country, 'NULL') = cp_country_cd OR
61: NVL(home_location_country, 'NULL') = cp_country_cd;
62: BEGIN
63: -- validate the deletion of IGS_PE_COUNTRY_CD record
64: p_message_name := null;
65: IF(p_country_cd IS NULL) THEN
66: RETURN TRUE;
67: END IF;