APPS.PVX_PARTY_MERGE_PKG dependencies on PV_LEAD_ASSIGNMENTS

Line 450: from PV_LEAD_ASSIGNMENTS

446: x_return_status OUT NOCOPY VARCHAR2)
447: IS
448: cursor c1 is
449: select 1
450: from PV_LEAD_ASSIGNMENTS
451: where partner_id = p_from_fk_id
452: for update nowait;
453:
454:

Line 499: FROM pv_lead_assignments

495:
496:
497: IF p_from_fk_id <> p_to_fk_id THEN
498: FOR x IN (SELECT DISTINCT partner_id
499: FROM pv_lead_assignments
500: WHERE partner_id = p_to_fk_id)
501: LOOP
502: p_to_id := x.partner_id;
503: END LOOP;

Line 507: FROM pv_lead_assignments

503: END LOOP;
504:
505: IF (p_to_id IS NULL) THEN
506: FOR x IN (SELECT DISTINCT related_party_id
507: FROM pv_lead_assignments
508: WHERE related_party_id = p_to_fk_id)
509: LOOP
510: p_to_id := x.related_party_id;
511: END LOOP;

Line 514: UPDATE PV_LEAD_ASSIGNMENTS

510: p_to_id := x.related_party_id;
511: END LOOP;
512: END IF;
513:
514: UPDATE PV_LEAD_ASSIGNMENTS
515: SET partner_id = p_to_fk_id,
516: last_update_date = SYSDATE,
517: last_updated_by = G_USER_ID,
518: last_update_login = G_LOGIN_ID