79: L2.DISPLAYED_FIELD,
80: L3.DISPLAYED_FIELD
81: INTO CP_NLS_ALL,CP_NLS_VOID,CP_NLS_NA
82: FROM
83: AP_LOOKUP_CODES L1,
84: AP_LOOKUP_CODES L2,
85: AP_LOOKUP_CODES L3
86: WHERE L1.LOOKUP_TYPE = 'NLS REPORT PARAMETER'
87: AND L1.LOOKUP_CODE = 'ALL'
80: L3.DISPLAYED_FIELD
81: INTO CP_NLS_ALL,CP_NLS_VOID,CP_NLS_NA
82: FROM
83: AP_LOOKUP_CODES L1,
84: AP_LOOKUP_CODES L2,
85: AP_LOOKUP_CODES L3
86: WHERE L1.LOOKUP_TYPE = 'NLS REPORT PARAMETER'
87: AND L1.LOOKUP_CODE = 'ALL'
88: AND L2.LOOKUP_TYPE = 'NLS TRANSLATION'
81: INTO CP_NLS_ALL,CP_NLS_VOID,CP_NLS_NA
82: FROM
83: AP_LOOKUP_CODES L1,
84: AP_LOOKUP_CODES L2,
85: AP_LOOKUP_CODES L3
86: WHERE L1.LOOKUP_TYPE = 'NLS REPORT PARAMETER'
87: AND L1.LOOKUP_CODE = 'ALL'
88: AND L2.LOOKUP_TYPE = 'NLS TRANSLATION'
89: AND L2.LOOKUP_CODE = 'VOID'