VIEW: APPS.PA_PROJECT_TYPE_CLASSES_V

Source

View Text - Preformatted

SELECT L.LOOKUP_CODE , L.MEANING , L.START_DATE_ACTIVE , L.END_DATE_ACTIVE FROM PA_LOOKUPS L WHERE L.LOOKUP_TYPE = 'PROJECT TYPE CLASS' AND L.predefined_flag = decode (PA_INSTALL.is_billing_licensed(), 'N', 'C', L.predefined_flag)

View Text - HTML Formatted

SELECT L.LOOKUP_CODE
, L.MEANING
, L.START_DATE_ACTIVE
, L.END_DATE_ACTIVE
FROM PA_LOOKUPS L
WHERE L.LOOKUP_TYPE = 'PROJECT TYPE CLASS'
AND L.PREDEFINED_FLAG = DECODE (PA_INSTALL.IS_BILLING_LICENSED()
, 'N'
, 'C'
, L.PREDEFINED_FLAG)