DBA Data[Home] [Help]

APPS.PO_PARTIAL_FUNDING_PKG dependencies on PO_HEADERS_ALL

Line 48: FROM po_headers_all h,

44: AND Nvl(federal_flag,'N') = 'Y';
45: ELSE
46: SELECT 'Y'
47: INTO l_clm_document
48: FROM po_headers_all h,
49: po_doc_style_headers pdsh
50: WHERE h.po_header_id = p_doc_level_id
51: AND h.style_id = pdsh.style_id
52: AND Nvl(pdsh.clm_flag,'N') = 'Y';

Line 161: FROM po_headers_all

157: END IF;
158:
159: SELECT NVL(style_id,-1)
160: INTO l_style_id
161: FROM po_headers_all
162: WHERE po_header_id = p_doc_header_id;
163:
164: l_is_clm_enabled := po_doc_style_helper.get_clm_flag(p_style_id => l_style_id);
165:

Line 169: po_headers_all poh

165:
166: SELECT NVL(purch_encumbrance_flag,'N')
167: INTO l_po_enc_flag
168: FROM financials_system_params_all fsp,
169: po_headers_all poh
170: WHERE poh.po_header_id = p_doc_header_id
171: AND fsp.org_id = poh.org_id;
172:
173: IF (l_po_enc_flag = 'Y' AND l_is_clm_enabled = 'Y') THEN