APPS.PAY_CA_EMP_TAX_INF dependencies on HR_LOCATIONS

Line 37: HR_LOCATIONS hrl,

33: cursor csr_get_work_province is
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

Line 424: hr_locations hl,

420:
421: CURSOR csr_get_default_province IS
422: select pcp.province_abbrev, '70-'||pcp.province_code||'-0000' geocode
423: from per_assignments_f paf,
424: hr_locations hl,
425: pay_ca_provinces_v pcp
426: where paf.assignment_id = p_assignment_id
427: and p_effective_date between paf.effective_start_date
428: and paf.effective_end_date