[Home] [Help]
579: select hp.party_name
580: from hz_relationships porg,
581: hz_parties hp,
582: hz_organization_profiles hzop,
583: pv_partner_profiles pvpp
584: where porg.party_id = pc_partner_id
585: and porg.subject_table_name = 'HZ_PARTIES'
586: and porg.object_table_name = 'HZ_PARTIES'
587: and porg.relationship_code = 'PARTNER_OF'
896: CURSOR lc_address (pc_party_relation_id number) is
897: SELECT b.address_id, a.resource_id
898: FROM jtf_rs_resource_extns a,
899: as_party_addresses_v b,
900: pv_partner_profiles c
901: WHERE a.category = 'PARTNER'
902: AND sysdate between a.start_date_active and nvl(a.end_date_active,sysdate)
903: AND a.source_id = pc_party_relation_id
904: AND a.source_id = c.partner_id
1745: CURSOR lc_get_pt_ven_name(pc_party_id NUMBER) IS
1746: SELECT VENDOR.party_name
1747: FROM hz_parties VENDOR,
1748: hz_relationships PCONTACT,
1749: pv_partner_profiles PVPP
1750: WHERE PCONTACT.party_id = pc_party_id
1751: AND PCONTACT.subject_table_name = 'HZ_PARTIES'
1752: AND PCONTACT.object_table_name = 'HZ_PARTIES'
1753: AND PCONTACT.RELATIONSHIP_TYPE = 'EMPLOYMENT'
1765:
1766: cursor lc_get_pt_org_name(pc_item_type varchar2, pc_item_key varchar2) is
1767: select pt.party_name, pvas.partner_id
1768: from hz_parties pt,
1769: pv_partner_profiles pvpp,
1770: pv_lead_assignments pvas
1771: where pvas.wf_item_type = pc_item_type
1772: and pvas.wf_item_key = pc_item_key
1773: and pvas.partner_id = pvpp.partner_id
2564: SELECT 'PARTNER_OF', PVPP.partner_id, PARTNER.party_name, peav.attr_value
2565: FROM
2566: hz_parties PARTNER,
2567: hz_relationships CONTACT,
2568: pv_partner_profiles PVPP,
2569: pv_enty_attr_values peav
2570: WHERE CONTACT.party_id = pc_party_id
2571: AND CONTACT.subject_table_name = 'HZ_PARTIES'
2572: AND CONTACT.object_table_name = 'HZ_PARTIES'