APPS.IGS_EN_VAL_SP dependencies on IGS_PE_STATISTICS

Line 16: FROM IGS_PE_STATISTICS

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;
19: BEGIN
20: -- validate the deletion of IGS_PE_SUBURB_POSTCD record