APPS.PV_ASSIGNMENT_PVT dependencies on PV_PARTNER_PROFILES

Line 1243: pv_partner_profiles pvpp,

1239: select
1240: d.lead_id, 'PARTY', c.resource_id
1241: from
1242: pv_lead_assignments la,
1243: pv_partner_profiles pvpp,
1244: hz_relationships b,
1245: jtf_rs_resource_extns c,
1246: as_accesses_all d
1247: where

Line 1320: pv_partner_profiles pvpp,

1316: SELECT
1317: d.lead_id, 'PARTY', c.resource_id
1318: FROM
1319: pv_lead_assignments la,
1320: pv_partner_profiles pvpp,
1321: hz_relationships b,
1322: jtf_rs_resource_extns c,
1323: as_accesses_all d
1324: WHERE

Line 2312: update pv_partner_profiles

2308:
2309: if p_partner_id is not null then
2310: -- single and serial
2311:
2312: update pv_partner_profiles
2313: set oppty_last_offered_date = sysdate,
2314: object_version_number = object_version_number + 1,
2315: last_update_date = sysdate,
2316: last_updated_by = FND_GLOBAL.user_id,

Line 2323: update pv_partner_profiles

2319:
2320: else
2321: -- broadcast and joint
2322:
2323: update pv_partner_profiles
2324: set oppty_last_offered_date = sysdate,
2325: object_version_number = object_version_number + 1,
2326: last_update_date = sysdate,
2327: last_updated_by = FND_GLOBAL.user_id,

Line 2592: pv_partner_profiles b,

2588:
2589: FOR x IN (
2590: SELECT a.partner_id, c.party_name
2591: FROM pv_lead_assignments a,
2592: pv_partner_profiles b,
2593: hz_parties c
2594: WHERE a.wf_item_type = p_itemtype AND
2595: a.wf_item_key = p_itemkey AND
2596: a.status IN ('CM_APPROVED', 'CM_BYPASSED', 'CM_TIMEOUT') AND