DBA Data[Home] [Help]

APPS.PQP_PERASGADD_RIW dependencies on HR_LOOKUPS

Line 191: from hr_lookups hrl

187: ,c_lookup_code in varchar2
188: ,c_effective_date in date) is
189: select hrl.meaning
190: ,hrl.lookup_code
191: from hr_lookups hrl
192: where hrl.lookup_type = c_lookup_type
193: and hrl.lookup_code = c_lookup_code
194: and hrl.enabled_flag = 'Y'
195: and trunc(c_effective_date)