DBA Data[Home] [Help]

APPS.PER_PERRPROH_XMLP_PKG dependencies on PER_ASSIGNMENTS_F

Line 131: per_assignments_f asg

127:
128: select count(*)
129: into v_count_managers
130: from per_people_f peo,
131: per_assignments_f asg
132: where peo.person_id = asg.person_id
133: and asg.assignment_type in ('E','C') and asg.manager_flag = 'Y'
134: and asg.organization_id = organization_id_parent
135: and c_session_date between asg.effective_start_date

Line 157: per_assignments_f asg

153:
154: select count(*)
155: into v_count_managers
156: from per_people_f peo,
157: per_assignments_f asg
158: where peo.person_id = asg.person_id
159: and asg.assignment_type in ('E','C') and asg.manager_flag = 'Y'
160: and asg.organization_id = organization_id_child
161: and c_session_date between asg.effective_start_date