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 374: from PO_DOCUMENT_TYPES_ALL_TL T

370:
371: BEGIN
372:
373: SELECT T.TYPE_NAME into L_Type_Name
374: from PO_DOCUMENT_TYPES_ALL_TL T
375: WHERE T.LANGUAGE = userenv('LANG')
376: and T.DOCUMENT_TYPE_CODE IN ('PO', 'PA')
377: AND T.DOCUMENT_SUBTYPE = X_Subtype
378: and NVL(T.org_id, -99) = NVL(X_Org_Id, -99);