APPS.IEX_PAYMENT_CAMP_RPT_PKG dependencies on JTF_RS_REP_MANAGERS

Line 187: FROM jtf_rs_rep_managers b,

183: INTO l_res_cnt
184: FROM JTF_RS_RESOURCE_EXTNS
185: WHERE source_id IN
186: ( SELECT DISTINCT b.person_id
187: FROM jtf_rs_rep_managers b,
188: JTF_RS_RESOURCE_EXTNS a
189: WHERE b.manager_person_id = a.source_id
190: AND a.resource_id = p_collector
191: );--100000937);

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

192: IF l_res_cnt <> 0 THEN
193: l_res_qry := '(select distinct resource_id '||
194: 'from '|| 'JTF_RS_RESOURCE_EXTNS '||
195: 'where source_id in (select distinct b.person_id '||
196: 'from jtf_rs_rep_managers b, JTF_RS_RESOURCE_EXTNS a '||
197: 'where b.manager_person_id = a.source_id '|| 'and a.resource_id = '||p_collector;
198: l_where :=l_where||' and p.resource_id in '|| l_res_qry ;
199: l_where :=l_where||'))';
200: ELSE