APPS.AS_SALES_LEAD_REFERRAL dependencies on AS_ACCESSES_ALL

Line 326: l_person_id NUMBER;--as_accesses_all.person_id%type;

322: l_itemType CONSTANT VARCHAR2(30) := g_wf_itemtype_notify;
323: l_itemKey VARCHAR2(30);
324: l_user_id NUMBER;
325: l_user_name fnd_user.user_name%type;
326: l_person_id NUMBER;--as_accesses_all.person_id%type;
327: l_resource_id NUMBER;
328: l_customer_name VARCHAR2(80);
329: l_customer_city VARCHAR2(50);
330: l_customer_state VARCHAR2(30);

Line 374: FROM as_accesses_all acc, jtf_rs_resource_extns res, fnd_user usr

370:
371: -- Get External Sales Team People - Partner user name
372: CURSOR lc_ptnr_users (pc_lead_id number) IS
373: SELECT acc.salesforce_id, usr.user_name, usr.user_id
374: FROM as_accesses_all acc, jtf_rs_resource_extns res, fnd_user usr
375: WHERE acc.sales_lead_id = pc_lead_id
376: -- AND acc. salesforce_role_code = 'REFERRAL'
377: AND acc.person_id IS NULL
378: AND acc.salesforce_id = res.resource_id

Line 470: l_ptnr_salesforce_id as_accesses_all.salesforce_id%TYPE;

466: l_ref_comm_amt as_sales_leads.ref_comm_amt%TYPE;
467: l_ref_decline_reason as_sales_leads.ref_decline_reason%TYPE;
468: l_ref_decline_reason_meaning varchar2(100);
469: l_ref_comm_ltr_status as_sales_leads.ref_comm_ltr_status%TYPE;
470: l_ptnr_salesforce_id as_accesses_all.salesforce_id%TYPE;
471: l_assign_to_person_id number;
472: l_owner_user_name fnd_user.user_name%TYPE;
473: l_owner_user_id fnd_user.user_id%TYPE;
474: l_owner_source_id number;