DBA Data[Home] [Help]

APPS.PAY_CA_EMP_TAX_INF dependencies on HR_LOOKUPS

Line 22: HR_LOOKUPS lkp

18: select lkp.lookup_code,
19: lkp.meaning
20: from PER_ASSIGNMENTS_F paf,
21: PER_ADDRESSES pa,
22: HR_LOOKUPS lkp
23: where paf.assignment_id = p_assignment_id
24: and p_session_date between paf.effective_start_date and
25: paf.effective_end_date
26: and pa.person_id = paf.person_id

Line 38: HR_LOOKUPS lkp

34: select lkp.lookup_code,
35: lkp.meaning
36: from PER_ASSIGNMENTS_F paf,
37: HR_LOCATIONS hrl,
38: HR_LOOKUPS lkp
39: where paf.assignment_id = p_assignment_id
40: and p_session_date between paf.effective_start_date and
41: paf.effective_end_date
42: and paf.location_id = hrl.location_id