DBA Data[Home] [Help]

APPS.PJM_COMMITMENT_UTILS dependencies on PO_DOCUMENT_TYPES_ALL_TL

Line 14: from PO_DOCUMENT_TYPES_ALL_TL T

10:
11: BEGIN
12:
13: SELECT T.TYPE_NAME into L_Type_Name
14: from PO_DOCUMENT_TYPES_ALL_TL T
15: WHERE T.LANGUAGE = userenv('LANG')
16: and T.DOCUMENT_TYPE_CODE = 'REQUISITION'
17: AND T.DOCUMENT_SUBTYPE = X_Subtype
18: and NVL(T.org_id, -99) = NVL(X_Org_Id, -99);

Line 368: from PO_DOCUMENT_TYPES_ALL_TL T

364:
365: BEGIN
366:
367: SELECT T.TYPE_NAME into L_Type_Name
368: from PO_DOCUMENT_TYPES_ALL_TL T
369: WHERE T.LANGUAGE = userenv('LANG')
370: and T.DOCUMENT_TYPE_CODE IN ('PO', 'PA')
371: AND T.DOCUMENT_SUBTYPE = X_Subtype
372: and NVL(T.org_id, -99) = NVL(X_Org_Id, -99);