APPS.HR_PROCESS_PERSON_SS dependencies on PER_ALL_ASSIGNMENTS_F

Line 1813: from per_all_assignments_f asg,

1809:
1810: cursor check_payroll is
1811: select asg.assignment_id,
1812: asg.payroll_id, asg.soft_coding_keyflex_id
1813: from per_all_assignments_f asg,
1814: per_assignment_status_types pas
1815: where asg.assignment_status_type_id = pas.assignment_status_type_id
1816: and asg.person_id = p_person_id
1817: and p_effective_date between asg.effective_start_date

Line 1832: per_all_assignments_f asf, per_jobs_tl pj, hr_all_organization_units_tl hou

1828: AND api_name = 'HR_PROCESS_PERSON_SS.PROCESS_DUMMY_API';
1829:
1830: cursor get_job_and_asg is
1831: select pj.name, hou.name from
1832: per_all_assignments_f asf, per_jobs_tl pj, hr_all_organization_units_tl hou
1833: where asf.person_id = p_person_id and asf.primary_flag = 'Y'
1834: AND asf.organization_id = hou.organization_id(+)
1835: AND hou.language = userenv('LANG')
1836: AND asf.job_id = pj.job_id(+)

Line 5630: from per_all_assignments_f asg,

5626:
5627: cursor check_payroll is
5628: select asg.assignment_id,
5629: asg.payroll_id, asg.soft_coding_keyflex_id
5630: from per_all_assignments_f asg,
5631: per_assignment_status_types pas
5632: where asg.assignment_status_type_id = pas.assignment_status_type_id
5633: and asg.person_id = l_person_id
5634: and l_effective_date between asg.effective_start_date

Line 5673: l_asg_rec per_all_assignments_f%rowtype;

5669:
5670: l_orgid number;
5671: l_ex_emp varchar2(10) default null;
5672: l_rehire_reason varchar2(250);
5673: l_asg_rec per_all_assignments_f%rowtype;
5674: l_is_ethinic varchar2(10) := null;
5675:
5676: BEGIN
5677: --

Line 5931: update per_all_assignments_f set payroll_id=asg_pay_rec(i).payroll_id

5927: end if;
5928:
5929: if l_is_payroll_upd then
5930: FOR i IN asg_pay_rec.FIRST..asg_pay_rec.LAST LOOP
5931: update per_all_assignments_f set payroll_id=asg_pay_rec(i).payroll_id
5932: where assignment_id = asg_pay_rec(i).assignment_id and
5933: l_effective_date - 1 between effective_start_date and effective_end_date;
5934:
5935: update per_all_assignments_f set payroll_id=asg_pay_rec(i).payroll_id

Line 5935: update per_all_assignments_f set payroll_id=asg_pay_rec(i).payroll_id

5931: update per_all_assignments_f set payroll_id=asg_pay_rec(i).payroll_id
5932: where assignment_id = asg_pay_rec(i).assignment_id and
5933: l_effective_date - 1 between effective_start_date and effective_end_date;
5934:
5935: update per_all_assignments_f set payroll_id=asg_pay_rec(i).payroll_id
5936: where assignment_id = asg_pay_rec(i).assignment_id and
5937: assignment_id <> l_appl_assignment_id and
5938: l_effective_date between effective_start_date and effective_end_date;
5939: END LOOP;

Line 9426: update per_all_assignments_f set payroll_id=null where assignment_id = p_assignment_id and

9422: p_legislation => 'US')))
9423: and l_address_line1 is null) OR (l_date_of_birth is null) OR
9424: (p_soft_coding_keyflex_id is null and l_leg_code is not null) then
9425:
9426: update per_all_assignments_f set payroll_id=null where assignment_id = p_assignment_id and
9427: p_effective_date between effective_start_date and effective_end_date;
9428:
9429: p_is_payroll_upd := true;
9430: end if;