APPS.PV_SLSTEAM_MIGRTN_PVT dependencies on HZ_PARTIES

Line 1389: hz_parties b,

1385: asl.lead_number entity_id,
1386: b.party_name ,
1387: a.salesforce_id
1388: from pv_access_migration_log a,
1389: hz_parties b,
1390: pv_partner_profiles pvpp ,
1391: as_leads_all asl
1392: where a.partner_customer_id = pvpp.partner_id
1393: and pvpp.partner_party_id = b.party_id

Line 1447: hz_parties b,

1443: FOR x in
1444: ( select d.party_name entity, d.party_number entity_id,
1445: b.party_name , a.salesforce_id
1446: from pv_access_migration_log a,
1447: hz_parties b,
1448: pv_partner_profiles pvpp ,
1449: hz_parties d
1450: where a.partner_customer_id = pvpp.partner_party_id
1451: and pvpp.partner_party_id = b.party_id

Line 1449: hz_parties d

1445: b.party_name , a.salesforce_id
1446: from pv_access_migration_log a,
1447: hz_parties b,
1448: pv_partner_profiles pvpp ,
1449: hz_parties d
1450: where a.partner_customer_id = pvpp.partner_party_id
1451: and pvpp.partner_party_id = b.party_id
1452: and a.customer_id = d.party_id
1453: and a.action = 'DELETE_CORRUPT_CUST_PARTNER' )

Line 1507: hz_parties b,

1503: FOR x in
1504: ( select asl.description entity, asl.lead_number entity_id,
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

Line 1573: hz_parties b,

1569: asl.lead_number entity_id,
1570: b.party_name ,
1571: a.salesforce_id
1572: from pv_access_migration_log a,
1573: hz_parties b,
1574: pv_partner_profiles pvpp ,
1575: as_leads_all asl
1576: where a.partner_customer_id = pvpp.partner_party_id
1577: and pvpp.partner_party_id = b.party_id

Line 1634: hz_parties b,

1630: FOR x in
1631: ( select d.party_name entity, d.party_number entity_id,
1632: b.party_name , a.salesforce_id
1633: from pv_access_migration_log a,
1634: hz_parties b,
1635: pv_partner_profiles pvpp ,
1636: hz_parties d
1637: where a.partner_customer_id = pvpp.partner_id
1638: and pvpp.partner_party_id = b.party_id

Line 1636: hz_parties d

1632: b.party_name , a.salesforce_id
1633: from pv_access_migration_log a,
1634: hz_parties b,
1635: pv_partner_profiles pvpp ,
1636: hz_parties d
1637: where a.partner_customer_id = pvpp.partner_id
1638: and pvpp.partner_party_id = b.party_id
1639: and a.customer_id = d.party_id
1640: and a.action = 'INSERT_CUST_PARTY' )

Line 1694: hz_parties b,

1690: FOR x in
1691: ( select asl.description entity, asl.lead_number entity_id,
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

Line 1760: hz_parties b,

1756: asl.lead_number entity_id,
1757: b.party_name ,
1758: a.salesforce_id
1759: from pv_access_migration_log a,
1760: hz_parties b,
1761: pv_partner_profiles pvpp ,
1762: as_leads_all asl
1763: where a.partner_customer_id = pvpp.partner_id
1764: and pvpp.partner_party_id = b.party_id