APPS.PAY_CA_EMP_TAX_INF dependencies on PER_ASSIGNMENTS_F

Line 20: from PER_ASSIGNMENTS_F paf,

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

Line 36: from PER_ASSIGNMENTS_F paf,

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

Line 283: from per_assignments_f paf

279: procedure get_min_asg_start_date(p_assignment_id in number,
280: p_min_start_date out nocopy date) is
281: cursor csr_min_date is
282: select min(effective_start_date)
283: from per_assignments_f paf
284: where paf.assignment_id = p_assignment_id
285: and paf.assignment_type <> 'A';
286:
287: l_min_start_date date;

Line 423: from per_assignments_f paf,

419: p_effective_date between peft.effective_start_date and peft.effective_end_date;
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

Line 1330: l_assignment_id per_assignments_f.assignment_id%TYPE;

1326: --
1327: l_proc varchar2(72) := 'maintain_ca_employee_taxes';
1328: l_counter number := 0;
1329: l_effective_date date;
1330: l_assignment_id per_assignments_f.assignment_id%TYPE;
1331: l_fed_object_version_number
1332: pay_ca_emp_fed_tax_info_f.object_version_number%TYPE;
1333: l_fed_eff_start_date pay_ca_emp_fed_tax_info_f.effective_start_date%TYPE;
1334: l_fed_eff_end_date pay_ca_emp_fed_tax_info_f.effective_end_date%TYPE;

Line 1345: from per_assignments_f asg,

1341: -- rmonge Bug fix 3599825.
1342:
1343: cursor csr_asg_id(p_csr_assignment_id number) is
1344: select null
1345: from per_assignments_f asg,
1346: hr_organization_information bus
1347: where asg.assignment_id = p_csr_assignment_id
1348: and bus.organization_id = asg.business_group_id
1349: and bus.org_information9 = 'CA'

Line 1356: from per_assignments_f asg,

1352: and asg.effective_end_date ;
1353:
1354: cursor csr_adr_asg_id is
1355: select asg.assignment_id
1356: from per_assignments_f asg,
1357: per_periods_of_service pps
1358: where asg.person_id = pps.person_id
1359: and pps.period_of_service_id = p_period_of_service_id
1360: and p_effective_date between asg.effective_start_date