DBA Data[Home] [Help]

APPS.PER_PERRPROH_XMLP_PKG dependencies on PER_PEOPLE_F

Line 130: from per_people_f peo,

126: begin
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

Line 156: from per_people_f peo,

152: begin
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