APPS.IGS_EN_VAL_SP dependencies on IGS_PE_SUBURB_POSTCD

Line 14: cp_postcode IGS_PE_SUBURB_POSTCD.postcode%TYPE) IS

10: DECLARE
11: v_person_id IGS_PE_PERSON.person_id%TYPE;
12: v_other_detail VARCHAR(255);
13: CURSOR gc_person_statistics(
14: cp_postcode IGS_PE_SUBURB_POSTCD.postcode%TYPE) IS
15: SELECT person_id
16: FROM IGS_PE_STATISTICS
17: WHERE NVL(term_location_postcode, 0) = cp_postcode OR
18: NVL(home_location_postcode, 0) = cp_postcode;

Line 20: -- validate the deletion of IGS_PE_SUBURB_POSTCD record

16: FROM IGS_PE_STATISTICS
17: WHERE NVL(term_location_postcode, 0) = cp_postcode OR
18: NVL(home_location_postcode, 0) = cp_postcode;
19: BEGIN
20: -- validate the deletion of IGS_PE_SUBURB_POSTCD record
21: p_message_name := null;
22: IF(p_postcode IS NULL) THEN
23: RETURN TRUE;
24: END IF;