APPS.PV_SLSTEAM_MIGRTN_PVT dependencies on PV_LEAD_ASSIGNMENTS

Line 765: pv_lead_assignments ass,

761: FROM as_accesses_all ACC,
762: hz_relationships hz1,
763: pv_partner_profiles pvp,
764: as_leads_all asl,
765: pv_lead_assignments ass,
766: pv_lead_workflows pvw
767: WHERE ACC.lead_id is not null
768: AND ACC.partner_cont_party_id is not null
769: AND ACC.person_id is null

Line 1098: FROM pv_lead_assignments c,

1094: y.resource_id,
1095: c.partner_id,
1096: x.lead_id,
1097: x.org_id
1098: FROM pv_lead_assignments c,
1099: as_leads_all x,
1100: jtf_rs_resource_extns y
1101: WHERE wf_item_type IS NULL
1102: AND NOT EXISTS ( SELECT NULL

Line 1103: FROM pv_lead_assignments a, as_accesses_all b

1099: as_leads_all x,
1100: jtf_rs_resource_extns y
1101: WHERE wf_item_type IS NULL
1102: AND NOT EXISTS ( SELECT NULL
1103: FROM pv_lead_assignments a, as_accesses_all b
1104: WHERE a.partner_id = b.partner_customer_id
1105: AND a.lead_id = b.lead_id
1106: AND c.lead_id = a.lead_id
1107: AND c.partner_id = b.partner_customer_id

Line 1248: FROM pv_lead_assignments c,

1244: y.resource_id,
1245: c.partner_id,
1246: x.lead_id,
1247: x.org_id
1248: FROM pv_lead_assignments c,
1249: as_leads_all x,
1250: jtf_rs_resource_extns y
1251: WHERE c.status = 'ASSIGNED'
1252: AND NOT EXISTS ( SELECT NULL