DBA Data[Home] [Help]

APPS.PQP_PERASGADD_RIW dependencies on HR_LOOKUPS

Line 190: from hr_lookups hrl

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