DBA Data[Home] [Help]

APPS.PAY_CA_YEER_PKG dependencies on HR_LOOKUPS

Line 431: HR_LOOKUPS lkp

427: select count( distinct lkp.meaning )
428: into l_multi_jd
429: from PER_ALL_ASSIGNMENTS_F paf,
430: HR_LOCATIONS_ALL hrl,
431: HR_LOOKUPS lkp
432: where paf.person_id = p_person_id
433: and sv_reporting_year between
434: to_char(paf.effective_start_date,'YYYY') and
435: to_char(paf.effective_end_date,'YYYY')