APPS.BIX_DM_AGENT_CALL_SUMMARY_PKG dependencies on JTF_RS_RESOURCE_EXTNS

Line 304: from as_sales_leads asl, jtf_rs_resource_extns res

300: BEGIN
301:
302:
303: select budget_amount,currency_code into p_leads_amount, p_currency_code
304: from as_sales_leads asl, jtf_rs_resource_extns res
305: where asl.sales_lead_id = p_lead_id
306: and asl.created_by = res.user_id
307: --and asl.creation_date >= p_act_start_time
308: and res.resource_id = p_resource_id;

Line 331: jtf_rs_resource_extns res

327: select total_amount,currency_code,1
328: into p_opp_amount, p_currency_code,p_opp_won
329: from as_leads_all a,
330: as_statuses_vl asv,
331: jtf_rs_resource_extns res
332: where a.lead_id = p_opp_id
333: and a.status = asv.status_code
334: and asv.win_loss_indicator = 'W'
335: and res.resource_id = p_resource_id

Line 376: from CS_INCIDENTS_AUDIT_B AUD, JTF_RS_RESOURCE_EXTNS RES

372: into p_sr_status
373: from
374: (
375: select incident_status_id
376: from CS_INCIDENTS_AUDIT_B AUD, JTF_RS_RESOURCE_EXTNS RES
377: where AUD.INCIDENT_ID = p_sr_id
378: and AUD.last_update_date >= p_act_start_time
379: and RES.resource_id = p_resource_id
380: and AUD.last_updated_by = RES.user_id

Line 1233: from jtf_rs_resource_extns

1229: BEGIN
1230:
1231: select resource_id
1232: into g_ao_dummy_resource
1233: from jtf_rs_resource_extns
1234: where user_name = 'IECAOUSER';
1235:
1236: EXCEPTION
1237: WHEN OTHERS THEN