DBA Data[Home] [Help]

APPS.PER_PERRPRPH_XMLP_PKG dependencies on PER_PEOPLE_F

Line 111: from per_people_f peo,

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

Line 138: from per_people_f peo,

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