APPS.PV_SLSTEAM_MIGRTN_PVT dependencies on AS_SALES_LEADS

Line 581: as_sales_leads asl

577: acc.org_id
578: FROM as_accesses_all ACC,
579: hz_relationships hz1,
580: pv_partner_profiles pvp,
581: as_sales_leads asl
582: WHERE ACC.sales_lead_id is not null
583: AND ACC.partner_cont_party_id is not null
584: AND ACC.person_id is null
585: AND ASL.sales_lead_id = ACC.sales_lead_id

Line 1509: as_sales_leads asl

1505: b.party_name , a.salesforce_id
1506: from pv_access_migration_log a,
1507: hz_parties b,
1508: pv_partner_profiles pvpp ,
1509: as_sales_leads asl
1510: where a.partner_customer_id = pvpp.partner_party_id
1511: and pvpp.partner_party_id = b.party_id
1512: and asl.sales_lead_id = a.sales_lead_id
1513: and a.action = 'DELETE_CORRUPT_LEAD_PARTNER' )

Line 1696: as_sales_leads asl

1692: b.party_name , a.salesforce_id
1693: from pv_access_migration_log a,
1694: hz_parties b,
1695: pv_partner_profiles pvpp ,
1696: as_sales_leads asl
1697: where a.partner_customer_id = pvpp.partner_id
1698: and pvpp.partner_party_id = b.party_id
1699: and asl.sales_lead_id = a.sales_lead_id
1700: and a.action = 'INSERT_LEAD_PARTY' )