DBA Data[Home] [Help]

APPS.PV_BG_PARTNER_MATCHING_PUB dependencies on AS_STATUSES_B

Line 353: as_statuses_b b,

349:
350: FOR x IN (
351: SELECT b.opp_open_status_flag, c.lead_id
352: FROM as_leads_all a,
353: as_statuses_b b,
354: pv_lead_workflows c
355: WHERE a.lead_id = l_lead_id AND
356: a.status = b.status_code AND
357: b.opp_flag = 'Y' AND

Line 959: as_statuses_b b,

955:
956: FOR x IN (
957: SELECT b.opp_open_status_flag, c.lead_id , c.routing_status
958: FROM as_leads_all a,
959: as_statuses_b b,
960: pv_lead_workflows c
961: WHERE a.lead_id = l_lead_id AND a.status = b.status_code AND
962: b.opp_flag = 'Y' AND a.lead_id = c.lead_id (+) and c.latest_routing_flag (+) = 'Y')
963: LOOP