APPS.IEX_COLL_CAMP_SCHD_RPT_PKG dependencies on JTF_RS_REP_MANAGERS

Line 147: FROM jtf_rs_rep_managers b,

143: INTO l_res_cnt
144: FROM JTF_RS_RESOURCE_EXTNS
145: WHERE source_id IN
146: ( SELECT DISTINCT b.person_id
147: FROM jtf_rs_rep_managers b,
148: JTF_RS_RESOURCE_EXTNS a
149: WHERE b.manager_person_id = a.source_id
150: AND a.resource_id = p_collector
151: );

Line 156: 'from jtf_rs_rep_managers b, JTF_RS_RESOURCE_EXTNS a '||

152: IF l_res_cnt <> 0 THEN
153: l_res_qry := '(select distinct resource_id '||
154: 'from '|| 'JTF_RS_RESOURCE_EXTNS '||
155: 'where source_id in (select distinct b.person_id '||
156: 'from jtf_rs_rep_managers b, JTF_RS_RESOURCE_EXTNS a '||
157: 'where b.manager_person_id = a.source_id '|| 'and a.resource_id = '||p_collector;
158: l_where :=l_where||' and jii.resource_id in '|| l_res_qry ;
159: l_where :=l_where||'))';
160: ELSE