[Home] [Help]
323: SELECT CUST_ACCOUNT_ROLE_ID from hz_cust_account_roles where party_id=l_party_id;
324:
325:
326: CURSOR CHECK_RELATIONSHIP_EXIST(p_person_party_id NUMBER, p_partner_party_id NUMBER) IS
327: select hzrp.party_id from hz_org_contacts hzoc, hz_relationships hzrp
328: where hzoc.party_relationship_id = hzrp.relationship_id and
329: hzrp.relationship_code='EMPLOYEE_OF' and
330: hzrp.subject_id=p_person_party_id and
331: hzrp.object_id=p_partner_party_id
1447:
1448: cursor get_contact_details(rel_party_id NUMBER) IS
1449: select pvpp.partner_id, pvpp.PARTNER_GROUP_ID , person_hzp.PERSON_FIRST_NAME, person_hzp.person_last_name,
1450: hzoc.org_contact_id, org_hzp.party_name, rel_hzp.email_address
1451: from HZ_PARTIES PERSON_HZP, HZ_RELATIONSHIPS HZR, PV_PARTNER_PROFILES pvpp, hz_org_contacts hzoc, HZ_PARTIES ORG_HZP,
1452: hz_parties REL_HZP
1453: where HZR.party_id = rel_party_id
1454: and HZR.directional_flag = 'F'
1455: and hzr.relationship_code = 'EMPLOYEE_OF'
2053:
2054: cursor get_contact_details(rel_party_id NUMBER) IS
2055: select pvpp.partner_id, pvpp.PARTNER_GROUP_ID , person_hzp.PERSON_FIRST_NAME, person_hzp.person_last_name,
2056: hzoc.org_contact_id, org_hzp.party_name, rel_hzp.email_address
2057: from HZ_PARTIES PERSON_HZP, HZ_RELATIONSHIPS HZR, PV_PARTNER_PROFILES pvpp, hz_org_contacts hzoc, HZ_PARTIES ORG_HZP,
2058: hz_parties REL_HZP
2059: where HZR.party_id = rel_party_id
2060: and HZR.directional_flag = 'F'
2061: and hzr.relationship_code = 'EMPLOYEE_OF'