APPS.PV_ASSIGNMENT_PVT dependencies on AS_LEADS_ALL

Line 1709: ' hz_locations loc, hz_party_sites pty, as_leads_all lead '||

1705:
1706: if p_timeoutType = pv_assignment_pub.g_matched_timeout then
1707:
1708: l_query := l_query || ' ( select loc.country from '||
1709: ' hz_locations loc, hz_party_sites pty, as_leads_all lead '||
1710: ' where pty.location_id = loc.location_id '||
1711: ' and pty.party_site_id = lead.address_id '||
1712: ' and lead.lead_id = :2 ) ';
1713:

Line 2581: FOR x IN (SELECT lead_number FROM as_leads_all WHERE lead_id = l_lead_id) LOOP

2577:
2578: -- -----------------------------------------------------------------------------
2579: -- Log Offered status for each partner that have been approved by the CM(s).
2580: -- -----------------------------------------------------------------------------
2581: FOR x IN (SELECT lead_number FROM as_leads_all WHERE lead_id = l_lead_id) LOOP
2582: l_log_params_tbl(1).param_name := 'OPP_NUMBER';
2583: l_log_params_tbl(1).param_value := x.lead_number;
2584: END LOOP;
2585:

Line 2736: update as_leads_all

2732: end if;
2733:
2734: if l_entity = 'OPPORTUNITY' then
2735:
2736: update as_leads_all
2737: set prm_assignment_type = nvl(l_assignment_type, prm_assignment_type),
2738: auto_assignment_type = 'TAP'
2739: where lead_id = l_lead_id;
2740: