DBA Data[Home] [Help]

APPS.PAY_CA_YEER_PKG dependencies on HR_LOCATIONS_ALL

Line 335: HR_LOCATIONS_ALL hrl,

331:
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