APPS.AML_MONITOR_WF dependencies on AS_SALES_LEADS

Line 85: FROM as_sales_leads asl,

81:
82: -- Get Lead Info
83: CURSOR c_get_lead_info (c_sales_lead_id number) IS
84: SELECT hzl.country, asl.lead_rank_id, asl.creation_date
85: FROM as_sales_leads asl,
86: hz_party_sites hzp,
87: hz_locations hzl
88: WHERE hzl.location_id = hzp.location_id
89: AND hzp.party_site_id = asl.address_id

Line 750: FROM as_sales_leads

746: SELECT creation_date, last_update_date, lead_number, status_code,
747: assign_date, accept_flag, lead_rank_id, expiration_date,
748: assign_to_salesforce_id, assign_sales_group_id, current_reroutes, description,
749: customer_id
750: FROM as_sales_leads
751: WHERE sales_lead_id = c_sales_lead_id;
752:
753: CURSOR c_lead_owner (c_lead_id number) IS
754: SELECT usr.user_name

Line 755: FROM as_sales_leads lead, fnd_user usr

751: WHERE sales_lead_id = c_sales_lead_id;
752:
753: CURSOR c_lead_owner (c_lead_id number) IS
754: SELECT usr.user_name
755: FROM as_sales_leads lead, fnd_user usr
756: WHERE lead.sales_lead_id = c_lead_id
757: and lead.assign_to_person_id = usr.employee_id;
758:
759:

Line 1982: update as_sales_leads

1978:
1979: l_current_reroutes := l_current_reroutes + 1;
1980:
1981: begin
1982: update as_sales_leads
1983: set current_reroutes = l_current_reroutes
1984: where sales_lead_id = l_sales_lead_id;
1985: exception
1986: when others then

Line 2252: from as_sales_leads

2248: and status_code = c_status_code;
2249:
2250: cursor c_chk_lead_current_status (c_sales_lead_id number) is
2251: select status_code
2252: from as_sales_leads
2253: where sales_lead_id = c_sales_lead_id;
2254:
2255: cursor c_chk_timelag_to_stage (c_lookup_code varchar2) is
2256: select 'Y'

Line 2263: from as_sales_leads

2259: and lookup_code = c_lookup_code;
2260:
2261: cursor c_chk_lead_accepted (c_sales_lead_id number) is
2262: select accept_flag
2263: from as_sales_leads
2264: where sales_lead_id = c_sales_lead_id;
2265:
2266: BEGIN
2267:

Line 2351: from as_sales_leads

2347:
2348:
2349: select last_update_date
2350: into l_curr_last_update_date
2351: from as_sales_leads
2352: where sales_lead_id = l_sales_lead_id;
2353:
2354: -- bugfix# 2808633. The date comparasion cannot be done with equals. If the lead is updated , do not send out notification
2355: --if l_orig_last_update_date = l_curr_last_update_date then

Line 2479: from as_sales_leads

2475:
2476:
2477: select last_update_date
2478: into l_curr_last_update_date
2479: from as_sales_leads
2480: where sales_lead_id = l_sales_lead_id;
2481:
2482: if l_orig_last_update_date = l_curr_last_update_date then
2483: l_condition_true := 'Y';

Line 2813: FROM as_sales_leads asl,

2809: l_monitor_launch_date date;
2810: -- Get Lead Info
2811: CURSOR c_get_lead_info1 (c_sales_lead_id number) IS
2812: SELECT hzl.country, asl.lead_rank_id
2813: FROM as_sales_leads asl,
2814: hz_party_sites hzp,
2815: hz_locations hzl
2816: WHERE hzl.location_id = hzp.location_id
2817: AND hzp.party_site_id = asl.address_id

Line 3212: FROM as_sales_leads

3208:
3209: -- Get lead info
3210: CURSOR c_get_lead_details (c_sales_lead_id NUMBER) IS
3211: SELECT assign_date, assign_to_salesforce_id, assign_sales_group_id, assign_to_person_id
3212: FROM as_sales_leads
3213: WHERE sales_lead_id = c_sales_lead_id;
3214:
3215: CURSOR c_lead_owner (c_lead_id number) IS
3216: SELECT usr.user_name

Line 3217: FROM as_sales_leads lead, fnd_user usr

3213: WHERE sales_lead_id = c_sales_lead_id;
3214:
3215: CURSOR c_lead_owner (c_lead_id number) IS
3216: SELECT usr.user_name
3217: FROM as_sales_leads lead, fnd_user usr
3218: WHERE lead.sales_lead_id = c_lead_id
3219: and lead.assign_to_person_id = usr.employee_id;
3220:
3221: