APPS.HR_CA_PERSON_TERM_LEG_HOOK dependencies on PER_ASSIGNMENTS_F

Line 41: from per_assignments_f paf_o,

37: /* Getting all Terminated Assignments for the Person concerned */
38:
39: cursor c_get_assignments(p_person_id in number) is
40: select distinct assignment_id
41: from per_assignments_f paf_o,
42: per_assignment_status_types past
43: where paf_o.person_id = p_person_id
44: and paf_o.assignment_status_type_id = past.assignment_status_type_id
45: and past.per_system_status = 'TERM_ASSIGN'

Line 53: from per_assignments_f paf_a

49: and past.legislation_code = 'CA')
50: OR (past.legislation_code is null
51: and exists
52: (select 'x'
53: from per_assignments_f paf_a
54: where paf_a.assignment_id = paf_o.assignment_id
55: and paf_a.business_group_id = past.business_group_id)
56: )
57: )

Line 59: from per_assignments_f paf_i

55: and paf_a.business_group_id = past.business_group_id)
56: )
57: )
58: and paf_o.effective_end_date = (select max(paf_i.effective_end_date)
59: from per_assignments_f paf_i
60: where paf_i.assignment_id = paf_o.assignment_id) ;
61:
62: -- Fetching Federal Tax Rules details the latest record that needs to be
63: -- end dated as of New FPD

Line 101: ,per_assignments_f asg

97: CURSOR c_compl_pay_act(p_new_final_process_date in date) IS
98: SELECT NULL
99: FROM pay_payroll_actions ppa
100: ,pay_assignment_actions paa
101: ,per_assignments_f asg
102: ,per_periods_of_service pds
103: WHERE pds.period_of_service_id = p_period_of_service_id
104: AND pds.person_id = asg.person_id
105: AND asg.period_of_service_id = pds.period_of_service_id

Line 115: l_assignment_id per_assignments_f.assignment_id%type ;

111:
112: l_person_id per_people_f.person_id%type ;
113: l_old_fpd per_periods_of_service.final_process_date%type ;
114: l_final_process_date per_periods_of_service.final_process_date%type ;
115: l_assignment_id per_assignments_f.assignment_id%type ;
116: l_emp_fed_tax_inf_id pay_ca_emp_fed_tax_info_f.emp_fed_tax_inf_id%type ;
117: l_emp_prov_tax_inf_id pay_ca_emp_prov_tax_info_f.emp_province_tax_inf_id%type ;
118: l_eff_st_dt date ;
119: l_eff_end_dt date ;