APPS.PO_CLM_CLO_UTIL dependencies on PO_DOC_STYLE_HEADERS

Line 392: FROM PO_DOC_STYLE_HEADERS

388: x_enabled_flag := por_util_pkg.get_federal_enabled_flag;
389: ELSIF p_functional_area_code = 'PURCHASING' THEN
390: SELECT NVL(CLM_FLAG, 'N')
391: INTO x_enabled_flag
392: FROM PO_DOC_STYLE_HEADERS
393: WHERE STYLE_ID = p_document_style_id;
394:
395: ELSE
396: x_enabled_flag := 'Y';

Line 765: return ' EXISTS (SELECT REF.STYLE_ID FROM PO_DOC_STYLE_HEADERS REF WHERE

761: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'ProfileValue : '||ProfileValue);
762: END IF;
763:
764: IF ProfileValue <> 'N' THEN
765: return ' EXISTS (SELECT REF.STYLE_ID FROM PO_DOC_STYLE_HEADERS REF WHERE
766: REF.STYLE_ID = PO_HEADERS_ALL_SEC.STYLE_ID AND REF.CLM_FLAG=''Y'') ';
767: ELSE
768: return ' EXISTS (SELECT REF.STYLE_ID FROM PO_DOC_STYLE_HEADERS REF WHERE
769: REF.STYLE_ID = PO_HEADERS_ALL_SEC.STYLE_ID AND NVL(REF.CLM_FLAG,''N'') = ''N'') ';

Line 768: return ' EXISTS (SELECT REF.STYLE_ID FROM PO_DOC_STYLE_HEADERS REF WHERE

764: IF ProfileValue <> 'N' THEN
765: return ' EXISTS (SELECT REF.STYLE_ID FROM PO_DOC_STYLE_HEADERS REF WHERE
766: REF.STYLE_ID = PO_HEADERS_ALL_SEC.STYLE_ID AND REF.CLM_FLAG=''Y'') ';
767: ELSE
768: return ' EXISTS (SELECT REF.STYLE_ID FROM PO_DOC_STYLE_HEADERS REF WHERE
769: REF.STYLE_ID = PO_HEADERS_ALL_SEC.STYLE_ID AND NVL(REF.CLM_FLAG,''N'') = ''N'') ';
770: END IF;
771: ELSE
772: return ' 1=1 ';