APPS.IEX_PAYMENT_COLL_RPT_PKG dependencies on JTF_RS_RESOURCE_EXTNS

Line 168: from jtf_rs_resource_extns

164: IF p_collector IS NOT NULL THEN
165: -- FND_FILE.put_line( FND_FILE.LOG,'4.5');
166: select source_name
167: into l_collector
168: from jtf_rs_resource_extns
169: where resource_id=p_collector;
170: IF p_report_level='GROUP' THEN
171: SELECT DISTINCT COUNT(resource_id)
172: INTO l_res_cnt

Line 173: FROM JTF_RS_RESOURCE_EXTNS

169: where resource_id=p_collector;
170: IF p_report_level='GROUP' THEN
171: SELECT DISTINCT COUNT(resource_id)
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

Line 177: JTF_RS_RESOURCE_EXTNS a

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: );
181: IF l_res_cnt <> 0 THEN

Line 184: 'JTF_RS_RESOURCE_EXTNS '||

180: );
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||'))';

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

Line 226: 'jtf_rs_resource_extns j,'||

222: 'ar_payment_schedules_all s,'||
223: 'iex_del_pay_xref xdp,'||
224: 'ams_source_codes c,'||
225: 'hz_cust_accounts hca,'||
226: 'jtf_rs_resource_extns j,'||
227: 'iex_pay_receipt_xref xpr,'||
228: 'ar_cash_receipts_all r,'||
229: 'ar_system_parameters asp,'||
230: 'iex_lookups_v l '||

Line 288: 'ams_source_codes c,jtf_rs_resource_extns j,iex_pay_receipt_xref xpr,ar_cash_receipts_all r,'|| 'iex_lookups_v l '||

284: 'ROUND(SUM(gl_currency_api.convert_amount(r.currency_code,'''||p_currency||''',sysdate,'''||l_coll_rate||''',r.amount))/COUNT(DISTINCT(d.transaction_id)),2) Average_Invoices,'||
285: 'COUNT(DISTINCT(d.cust_account_id)) Accounts,'||
286: 'ROUND(SUM(gl_currency_api.convert_amount(r.currency_code,'''||p_currency||''',sysdate,'''||l_coll_rate||''',r.amount))/COUNT(DISTINCT(d.cust_account_id)),2) Average_Account '||
287: 'FROM '|| 'iex_delinquencies d,iex_payments p, ar_payment_schedules_all s , iex_del_pay_xref xdp,ar_system_parameters asp1,'||
288: 'ams_source_codes c,jtf_rs_resource_extns j,iex_pay_receipt_xref xpr,ar_cash_receipts_all r,'|| 'iex_lookups_v l '||
289: 'WHERE xdp.payment_id = p.payment_id '|| 'AND xdp.DELINQUENCY_ID = d.DELINQUENCY_ID '||
290: 'AND d.payment_schedule_id = s.payment_schedule_id '|| 'AND c.source_code_id(+) = p.campaign_sched_id '||'and d.org_id = asp1.org_id '||
291: 'AND p.resource_id = j.resource_id(+) '|| 'AND p.payment_id = xpr.payment_id '|| 'AND r.cash_receipt_id = xpr.cash_receipt_id '||
292: 'AND l.lookup_type = ''IEX_PAYMENT_TYPES'' '|| 'AND p.payment_method= l.lookup_code '|| 'AND s.class =''INV'' ';