DBA Data[Home] [Help]

APPS.AS_SALES_METH_WF dependencies on AS_LEADS_ALL

Line 104: FROM as_leads_all a,as_sales_methodology_b b

100: FROM jtf_rs_resource_extns
101: WHERE resource_id = p_owner_id ;
102: CURSOR c_meth IS
103: SELECT b.autocreatetask_flag,b.sales_methodology_id
104: FROM as_leads_all a,as_sales_methodology_b b
105: WHERE a.lead_id = p_source_object_id
106: AND a.sales_methodology_id = b.sales_methodology_id;
107: CURSOR c_stage IS
108: SELECT a.sales_stage_id,task_template_group_id

Line 583: SELECT sales_methodology_id from as_leads_all a

579: l_api_name VARCHAR2(2000);
580: table_row NUMBER;
581: l_taask_id NUMBER;
582: CURSOR c_Methodology IS
583: SELECT sales_methodology_id from as_leads_all a
584: WHERE a.lead_id = l_source_object_id;
585: CURSOR c_task IS
586: SELECT template_id,template_group_id
587: FROM JTF_TASKS_B where task_id = l_taask_id;

Line 593: from as_leads_all

589: -- Added for bug 2596419 start
590:
591: CURSOR c_customer_info (c_lead_id NUMBER) IS
592: select customer_id, address_id
593: from as_leads_all
594: where lead_id = c_lead_id;
595:
596: CURSOR c_primary_address(c_customer_id NUMBER) IS
597: select party_site_id