DBA Data[Home] [Help]

APPS.PJM_INQUIRY dependencies on PO_DOCUMENT_TYPES_ALL_TL

Line 46: from PO_DOCUMENT_TYPES_ALL_TL T

42:
43: BEGIN
44:
45: SELECT T.TYPE_NAME into L_Type_Name
46: from PO_DOCUMENT_TYPES_ALL_TL T
47: WHERE T.LANGUAGE = userenv('LANG')
48: and T.DOCUMENT_TYPE_CODE = 'RELEASE'
49: AND T.DOCUMENT_SUBTYPE = X_Sybtype
50: and T.org_id = X_Org_Id;

Line 272: from PO_DOCUMENT_TYPES_ALL_TL T

268:
269: BEGIN
270:
271: SELECT T.TYPE_NAME into L_Type_Name
272: from PO_DOCUMENT_TYPES_ALL_TL T
273: WHERE T.LANGUAGE = userenv('LANG')
274: and T.DOCUMENT_TYPE_CODE IN ('PO', 'PA')
275: AND T.DOCUMENT_SUBTYPE = 'STANDARD'
276: and T.org_id = X_Org_Id;