DBA Data[Home] [Help]

APPS.PER_PERRPRPH_XMLP_PKG dependencies on PER_ASSIGNMENTS_F

Line 112: per_assignments_f asg

108:
109: select count(*)
110: into v_count_holders
111: from per_people_f peo,
112: per_assignments_f asg
113: where peo.person_id = asg.person_id
114: and asg.position_id = parent_position_id
115: and c_session_date between peo.effective_start_date
116: and peo.effective_end_date

Line 139: per_assignments_f asg

135:
136: select count(*)
137: into v_count_holders
138: from per_people_f peo,
139: per_assignments_f asg
140: where peo.person_id = asg.person_id
141: and asg.position_id = subordinate_position_id
142: and c_session_date between peo.effective_start_date
143: and peo.effective_end_date