APPS.GR_SUB_HEADINGS_B_PKG dependencies on GR_ITEM_DOCUMENT_DTLS
Line 647: FROM gr_item_document_dtls idd
643: */
644: CURSOR c_get_item_doc
645: IS
646: SELECT COUNT(*) 647: FROM gr_item_document_dtls idd 648: WHERE idd.sub_heading_code = p_sub_heading_code;
649:
650: BEGIN
651:
Line 678: l_msg_data := l_msg_data || ' gr_item_document_dtls,';
674: OPEN c_get_item_doc;
675: FETCH c_get_item_doc INTO l_record_count;
676: IF l_record_count <> 0 THEN
677: l_return_status := 'E'; 678: l_msg_data := l_msg_data || ' gr_item_document_dtls,'; 679: END IF;
680: CLOSE c_get_item_doc;
681:
682: IF l_return_status <> 'S' THEN