APPS.GHR_EXEMP_PURGE dependencies on GHR_COMPLAINTS2

Line 500: GHR_COMPLAINTS2

496:
497: CURSOR FETCH_COMPL_PPL
498: IS
499: SELECT COMPLAINT_ID FROM
500: GHR_COMPLAINTS2
501: WHERE COMPLAINANT_PERSON_ID = p_person_id;
502:
503:
504: BEGIN

Line 548: DELETE FROM GHR_COMPLAINTS2

544: DELETE FROM GHR_COMPL_PEOPLE
545: WHERE COMPLAINT_ID = compl_ppl.COMPLAINT_ID;
546: END LOOP;
547:
548: DELETE FROM GHR_COMPLAINTS2
549: WHERE COMPLAINANT_PERSON_ID = p_person_id;
550:
551: DELETE FROM GHR_COMPL_PEOPLE
552: WHERE PERSON_ID = p_person_id;