DBA Data[Home] [Help]

APPS.PAY_CA_YEER_PKG dependencies on HR_LOCATIONS_ALL

Line 430: HR_LOCATIONS_ALL hrl,

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