[Home] [Help]
1823:
1824: BEGIN
1825:
1826: SELECT 'Y' INTO is_ja_notice_posted
1827: FROM pon_fbo_posts
1828: WHERE document_id = l_document_id
1829: AND FORM_CODE = 'FED_JA'
1830: AND fbo_post_status = 'SUCCESS'
1831: AND ROWNUM =1;