DBA Data[Home] [Help]

APPS.PQP_HROSS_INTEGRATION dependencies on HR_LOOKUPS

Line 132: FROM hr_lookups hrl

128: ,c_lookup_code IN Varchar2
129: ,c_effective_date IN Date) IS
130: SELECT hrl.meaning
131: ,hrl.lookup_code
132: FROM hr_lookups hrl
133: WHERE hrl.lookup_type = c_lookup_type
134: AND hrl.lookup_code = c_lookup_code
135: AND hrl.enabled_flag = 'Y'
136: AND Trunc(c_effective_date)