APPS.PO_DOC_STYLE_HELPER SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 18

	SELECT DECODE(NVL(CHANGE_PROCESS_TYPE,'CHANGE_ORDER'),'MODIFICATION','Y','N')
	INTO l_is_formal_chng_req
	FROM PO_DOC_STYLE_HEADERS
	WHERE STYLE_ID = p_style_id;

Line: 49

	SELECT NVL(CLM_FLAG,'N')
	INTO l_clm_flag
	FROM PO_DOC_STYLE_HEADERS
	WHERE STYLE_ID = p_style_id;

Line: 79

	SELECT NVL(CLM_FLAG,'N')
	INTO l_clm_flag
	FROM PO_DOC_STYLE_HEADERS pdsh, po_headers_all pha
	WHERE pha.po_header_id = p_po_header_id
  AND   pha.STYLE_ID = pdsh.style_id;