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

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