APPS.GR_DISCLOSURE_PKG dependencies on GR_DOCUMENT_PRINT

Line 93: /* Cursor to call disclosure code out of GR_DOCUMENT_PRINT (The Recipient Disclosure) */

89: SELECT COUNT(1)
90: FROM gr_item_disclosures id
91: WHERE id.disclosure_code = delete_disclosure;
92:
93: /* Cursor to call disclosure code out of GR_DOCUMENT_PRINT (The Recipient Disclosure) */
94: CURSOR docprint_rec_disclosure_cursor
95: IS
96: SELECT COUNT(1)
97: FROM gr_document_print dp

Line 97: FROM gr_document_print dp

93: /* Cursor to call disclosure code out of GR_DOCUMENT_PRINT (The Recipient Disclosure) */
94: CURSOR docprint_rec_disclosure_cursor
95: IS
96: SELECT COUNT(1)
97: FROM gr_document_print dp
98: WHERE dp.disclosure_code_recipient = delete_disclosure;
99:
100: /* Cursor to call disclosure code out of GR_DOCUMENT_PRINT (The Country Disclosure) */
101: CURSOR docprint_con_disclosure_cursor

Line 100: /* Cursor to call disclosure code out of GR_DOCUMENT_PRINT (The Country Disclosure) */

96: SELECT COUNT(1)
97: FROM gr_document_print dp
98: WHERE dp.disclosure_code_recipient = delete_disclosure;
99:
100: /* Cursor to call disclosure code out of GR_DOCUMENT_PRINT (The Country Disclosure) */
101: CURSOR docprint_con_disclosure_cursor
102: IS
103: SELECT COUNT(1)
104: FROM gr_document_print dp

Line 104: FROM gr_document_print dp

100: /* Cursor to call disclosure code out of GR_DOCUMENT_PRINT (The Country Disclosure) */
101: CURSOR docprint_con_disclosure_cursor
102: IS
103: SELECT COUNT(1)
104: FROM gr_document_print dp
105: WHERE dp.disclosure_code_country = delete_disclosure;
106:
107: /* Cursor to call disclosure code out of GR_RECIPIENT_INFO */
108: CURSOR recip_disclosure_cursor

Line 146: l_table_name := 'GR_DOCUMENT_PRINT';

142: END IF;
143:
144: /* Check the Document Print table for both the Recipient and the Country Disclosure Code */
145:
146: l_table_name := 'GR_DOCUMENT_PRINT';
147:
148: OPEN docprint_rec_disclosure_cursor;
149: FETCH docprint_rec_disclosure_cursor INTO l_count;
150: CLOSE docprint_rec_disclosure_cursor;