DBA Data[Home] [Help]

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 16129: from per_all_assignments_f

16125:
16126: /*
16127: cursor csr_new_object_number(p_asg_id in number) is
16128: select object_version_number
16129: from per_all_assignments_f
16130: where assignment_id = p_asg_id
16131: and assignment_type = 'E'
16132: order by object_version_number desc;
16133: */