79: /* Cursor to call disclosure code out of GR_COUNTRY */
80: CURSOR country_disclosure_cursor
81: IS
82: SELECT COUNT(1)
83: FROM gr_country_profiles cp
84: WHERE cp.disclosure_code = delete_disclosure;
85:
86: /* Cursor to call disclosure code out of GR_ITEM_DISCLOSURE */
87: CURSOR itemdisc_disclosure_cursor
112: WHERE ri.disclosure_code = delete_disclosure;
113:
114: BEGIN
115:
116: l_table_name := 'GR_COUNTRY_PROFILES';
117:
118: /*
119: ** Open cursor which counts total records that match the item code to be deleted
120: */