DBA Data[Home] [Help]

APPS.PAY_CA_YEER_PKG dependencies on HR_LOOKUPS

Line 336: HR_LOOKUPS lkp

332: select count( distinct lkp.meaning )
333: into l_multi_jd
334: from PER_ALL_ASSIGNMENTS_F paf,
335: HR_LOCATIONS_ALL hrl,
336: HR_LOOKUPS lkp
337: where paf.person_id = p_person_id
338: and sv_reporting_year between
339: to_char(paf.effective_start_date,'YYYY') and
340: to_char(paf.effective_end_date,'YYYY')