APPS.PO_CLM_INTG_GRP dependencies on PO_HEADERS_ALL

Line 39: l_style_id po_headers_all.style_id%TYPE;

35: RETURN VARCHAR2
36: IS
37: d_module VARCHAR2(70) := 'po.plsql.PO_CLM_INTG_GRP.is_CLM_po';
38: d_progress NUMBER;
39: l_style_id po_headers_all.style_id%TYPE;
40: l_po_header_id po_headers_all.po_header_id%TYPE;
41: l_is_clm_po VARCHAR2(1) := 'N';
42: l_count NUMBER := 0;
43: BEGIN

Line 40: l_po_header_id po_headers_all.po_header_id%TYPE;

36: IS
37: d_module VARCHAR2(70) := 'po.plsql.PO_CLM_INTG_GRP.is_CLM_po';
38: d_progress NUMBER;
39: l_style_id po_headers_all.style_id%TYPE;
40: l_po_header_id po_headers_all.po_header_id%TYPE;
41: l_is_clm_po VARCHAR2(1) := 'N';
42: l_count NUMBER := 0;
43: BEGIN
44: d_progress := 0;

Line 67: FROM po_headers_all h,

63:
64:
65: SELECT 'Y'
66: INTO l_is_clm_po
67: FROM po_headers_all h,
68: po_doc_style_headers pdsh
69: WHERE h.po_header_id = l_po_header_id
70: AND h.style_id = pdsh.style_id
71: AND NVL(pdsh.clm_flag,'N') = 'Y';

Line 761: FROM po_headers_all h,

757:
758: ELSE
759: SELECT 'Y'
760: INTO l_clm_document
761: FROM po_headers_all h,
762: po_doc_style_headers pdsh
763: WHERE h.po_header_id = p_document_id
764: AND h.style_id = pdsh.style_id
765: AND NVL(pdsh.clm_flag,'N') = 'Y';