[Home] [Help]
2258: select p.party_type, p.status, p.object_version_number,
2259: rel.relationship_id,rel.object_version_number rel_object_version_number,
2260: oc.org_contact_id,oc.object_version_number cont_object_version_number,
2261: a.cust_account_id,a.object_version_number acct_object_version_number
2262: from hz_parties p, hz_relationships rel,hz_cust_accounts a,hz_org_contacts oc
2263: where p.party_id = l_party_id and rel.party_id(+) = p.party_id and a.party_id(+) = p.party_id
2264: and oc.party_relationship_id(+) = rel.relationship_id and rownum <2;
2265: rec_party_info c_getPartyInfo%rowtype;
2266:
2277: where party_id = l_party_id;
2278: rec_party_site c_getPartySite%rowtype;
2279:
2280: cursor c_getPersonOrgPartyId(l_party_id number) IS
2281: select subject_id,object_id from hz_relationships
2282: where party_id = l_party_id and subject_type = 'ORGANIZATION';
2283:
2284: cursor c_getCustAcctRole(l_party_id number) IS
2285: select cust_account_role_id,object_version_number
2749: )
2750: as
2751:
2752: cursor c_get_party_relationship (c_subject_id NUMBER, c_object_id NUMBER) is
2753: SELECT party_id FROM hz_relationships
2754: WHERE subject_id = c_subject_id and subject_type = 'PERSON'
2755: and object_id = c_object_id and object_type = 'ORGANIZATION';
2756:
2757: cursor c_get_contact_preference (c_party_id NUMBER,c_table_name VARCHAR2) is