APPS.HR_PROCESS_CONTACT_SS dependencies on PER_ALL_ASSIGNMENTS_F

Line 116: from per_all_assignments_f asg

112: -- otherwise his payroll will get affected.
113: --
114: and not exists
115: (select null
116: from per_all_assignments_f asg
117: where trunc(sysdate) between asg.effective_start_date
118: and asg.effective_end_date
119: and asg.person_id = addr.person_id
120: and asg.primary_flag = 'Y'

Line 15961: from per_all_assignments_f

15957:
15958: /*
15959: cursor csr_new_object_number(p_asg_id in number) is
15960: select object_version_number
15961: from per_all_assignments_f
15962: where assignment_id = p_asg_id
15963: and assignment_type = 'E'
15964: order by object_version_number desc;
15965: */