DBA Data[Home] [Help]

APPS.PON_CLM_CLO_UTIL_PKG dependencies on PO_DOCUMENT_TYPES_VL

Line 1834: FROM po_document_types_vl

1830: IF(p_caller='PON') THEN
1831:
1832: SELECT type_name
1833: INTO l_doc_type_dsp
1834: FROM po_document_types_vl
1835: WHERE document_type_code = 'SOLICITATION'
1836: AND document_subtype = 'SOLICITATION'
1837: AND ORG_ID = Nvl(PO_MOAC_UTILS_PVT.GET_CURRENT_ORG_ID, FND_GLOBAL.ORG_ID);
1838:

Line 1843: FROM po_document_types_vl pdt,

1839: ELSE
1840:
1841: SELECT Decode(p_caller,'PO_MOD', type_name ||' '|| FND_MESSAGE.GET_STRING('PO','PO_MODIFICATION') ,type_name)
1842: INTO l_doc_type_dsp
1843: FROM po_document_types_vl pdt,
1844: po_headers_draft_all poh
1845: WHERE pdt.document_type_code IN ('PO', 'PA')
1846: AND pdt.ORG_ID =Nvl(PO_MOAC_UTILS_PVT.GET_CURRENT_ORG_ID,
1847: FND_GLOBAL.ORG_ID)