[Home] [Help]
16: /* Cursor to get the resident state, county and city codes */
17: cursor csr_get_resident_province is
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
32:
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
281: procedure get_min_asg_start_date(p_assignment_id in number,
282: p_min_start_date out nocopy date) is
283: cursor csr_min_date is
284: select min(effective_start_date)
285: from per_assignments_f paf
286: where paf.assignment_id = p_assignment_id
287: and paf.assignment_type <> 'A';
288:
289: l_min_start_date date;
421: p_effective_date between peft.effective_start_date and peft.effective_end_date;
422:
423: CURSOR csr_get_default_province IS
424: select pcp.province_abbrev, '70-'||pcp.province_code||'-0000' geocode
425: from per_assignments_f paf,
426: hr_locations hl,
427: pay_ca_provinces_v pcp
428: where paf.assignment_id = p_assignment_id
429: and p_effective_date between paf.effective_start_date
1546: --
1547: l_proc varchar2(72) := 'maintain_ca_employee_taxes';
1548: l_counter number := 0;
1549: l_effective_date date;
1550: l_assignment_id per_assignments_f.assignment_id%TYPE;
1551: l_fed_object_version_number
1552: pay_ca_emp_fed_tax_info_f.object_version_number%TYPE;
1553: l_fed_eff_start_date pay_ca_emp_fed_tax_info_f.effective_start_date%TYPE;
1554: l_fed_eff_end_date pay_ca_emp_fed_tax_info_f.effective_end_date%TYPE;
1561: -- rmonge Bug fix 3599825.
1562:
1563: cursor csr_asg_id(p_csr_assignment_id number) is
1564: select null
1565: from per_assignments_f asg,
1566: hr_organization_information bus
1567: where asg.assignment_id = p_csr_assignment_id
1568: and bus.organization_id = asg.business_group_id
1569: and bus.org_information9 = 'CA'
1572: and asg.effective_end_date ;
1573:
1574: cursor csr_adr_asg_id is
1575: select asg.assignment_id
1576: from per_assignments_f asg,
1577: per_periods_of_service pps
1578: where asg.person_id = pps.person_id
1579: and pps.period_of_service_id = p_period_of_service_id
1580: and p_effective_date between asg.effective_start_date