APPS.GR_COVER_LETTERS_B_PKG dependencies on GR_COVER_LETTERS_TL
Line 637: FROM gr_cover_letters_tl clt
633:
634: CURSOR c_get_letter_text
635: IS
636: SELECT COUNT(*) 637: FROM gr_cover_letters_tl clt 638: WHERE clt.cover_letter_id = p_cover_letter_id;
639:
640:
641: BEGIN
Line 655: l_msg_data := l_msg_data || ' gr_cover_letters_tl';
651: OPEN c_get_letter_text;
652: FETCH c_get_letter_text INTO l_record_count;
653: IF l_record_count <> 0 THEN
654: l_return_status := 'E'; 655: l_msg_data := l_msg_data || ' gr_cover_letters_tl'; 656: END IF;
657: CLOSE c_get_letter_text;
658: IF l_return_status <> 'S' THEN
659: RAISE INTEGRITY_ERROR;