APPS.IEX_PAYMENT_COLL_RPT_PKG dependencies on JTF_RS_REP_MANAGERS

Line 176: FROM jtf_rs_rep_managers b,

172: INTO l_res_cnt
173: FROM JTF_RS_RESOURCE_EXTNS
174: WHERE source_id IN
175: ( SELECT DISTINCT b.person_id
176: FROM jtf_rs_rep_managers b,
177: JTF_RS_RESOURCE_EXTNS a
178: WHERE b.manager_person_id = a.source_id
179: AND a.resource_id = p_collector
180: );

Line 185: 'where source_id in (select distinct b.person_id '|| 'from jtf_rs_rep_managers b, JTF_RS_RESOURCE_EXTNS a '||

181: IF l_res_cnt <> 0 THEN
182: l_res_qry := '(select distinct resource_id '||
183: 'from '||
184: 'JTF_RS_RESOURCE_EXTNS '||
185: 'where source_id in (select distinct b.person_id '|| 'from jtf_rs_rep_managers b, JTF_RS_RESOURCE_EXTNS a '||
186: 'where b.manager_person_id = a.source_id '|| 'and a.resource_id = '||p_collector;
187: l_where :=l_where||' and p.resource_id in '|| l_res_qry ;
188: l_where :=l_where||'))';
189: ELSE