APPS.HR_PROCESS_PERSON_SS dependencies on PER_ALL_ASSIGNMENTS_F

Line 1663: select payroll_id from per_all_assignments_f where

1659: AND wp.activity_name = c_activity_name
1660: );
1661:
1662: cursor check_payroll is
1663: select payroll_id from per_all_assignments_f where
1664: person_id = p_person_id and p_effective_date between
1665: effective_start_date and effective_end_date;
1666:
1667: dummy number;

Line 5247: select payroll_id from per_all_assignments_f where

5243: WHERE oi.organization_id = l_organization_id
5244: AND oi.org_information_context = 'Business Group Information';
5245:
5246: cursor check_payroll is
5247: select payroll_id from per_all_assignments_f where
5248: person_id = l_person_id and l_effective_date between
5249: effective_start_date and effective_end_date;
5250:
5251: dummy_payroll_id number;

Line 5403: update per_all_assignments_f set payroll_id=dummy_payroll_id where assignment_id = l_appl_assignment_id and

5399: ,p_source => true);
5400: -- ,p_original_date_of_hire => l_original_date_of_hire); --bug 4416684, pass original_date_of_hire
5401:
5402: if l_is_payroll_upd then
5403: update per_all_assignments_f set payroll_id=dummy_payroll_id where assignment_id = l_appl_assignment_id and
5404: l_effective_date - 1 between effective_start_date and effective_end_date;
5405: end if;
5406:
5407: -- get the person_type_id in the rollback segment

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

8832: and hr_utility.chk_product_install(p_product => 'Oracle Payroll',
8833: p_legislation => 'US')))
8834: and l_address_line1 is null) OR (l_date_of_birth is null) then
8835:
8836: update per_all_assignments_f set payroll_id=null where assignment_id = p_assignment_id and
8837: p_effective_date between effective_start_date and effective_end_date;
8838:
8839: p_is_payroll_upd := true;
8840: end if;