APPS.IGI_IMP_IAC_PURGE_PKG dependencies on IGI_IMP_IAC_INTERMEDIATE

Line 74: DELETE FROM IGI_IMP_IAC_INTERMEDIATE

70:
71: DELETE FROM IGI_IMP_IAC_INTERFACE_PY_ADD
72: WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE;
73:
74: DELETE FROM IGI_IMP_IAC_INTERMEDIATE
75: WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE;
76:
77: ELSIF category_count > 0 AND asset_count = 0 THEN
78:

Line 88: DELETE FROM IGI_IMP_IAC_INTERMEDIATE

84:
85: DELETE FROM IGI_IMP_IAC_INTERFACE_PY_ADD
86: WHERE CATEGORY_ID = p_category_id;
87:
88: DELETE FROM IGI_IMP_IAC_INTERMEDIATE
89: WHERE CATEGORY_ID = p_category_id;
90:
91: ELSE
92:

Line 99: DELETE FROM IGI_IMP_IAC_INTERMEDIATE

95:
96: DELETE FROM IGI_IMP_IAC_INTERFACE_PY_ADD
97: WHERE ASSET_ID = p_asset_id;
98:
99: DELETE FROM IGI_IMP_IAC_INTERMEDIATE
100: WHERE ASSET_ID = p_asset_id;
101:
102:
103: END IF;