[Home] [Help]
590:
591: CURSOR cur_cust_user(p_contact_id IN NUMBER,p_object_id IN number) IS
592: SELECT f.user_name ,( hz.person_first_name||' '||hz.person_last_name ) contact_name FROM
593: hz_relationships hr,
594: hz_parties hz,
595: FND_USER f
596: WHERE
597: hr.party_id = p_contact_id
598: AND hr.subject_id = hz.party_id
597: hr.party_id = p_contact_id
598: AND hr.subject_id = hz.party_id
599: AND hr.object_id = p_object_id
600: AND hr.object_type = 'ORGANIZATION'
601: AND hr.object_table_name = 'HZ_PARTIES'
602: AND hr.subject_type = 'PERSON'
603: AND hz.party_id = hr.subject_id
604: AND hr.relationship_code = 'CONTACT_OF'
605: AND hr.status = 'A'
1025: l_party_name VARCHAR2(450); -- set to 360 in OKC_REP_IMP_PARTIES_T
1026: -- For HZ_PARTY validation, using document "TCA Usage Guideline" Version 3.0
1027: CURSOR partner_csr IS
1028: SELECT party_name, status
1029: FROM hz_parties
1030: WHERE party_id = p_party_id
1031: AND party_type IN ('ORGANIZATION', 'PERSON'); /*--10334886: Added person party Type*/
1032: partner_rec partner_csr%ROWTYPE;
1033:
1236: SELECT hz.party_name contact_name,
1237: hr.status relationship_status,
1238: hr.start_date start_date,
1239: hr.end_date end_date
1240: FROM hz_parties hz,
1241: hz_relationships hr
1242: WHERE hr.object_id = p_party_id -- The party being passsed
1243: AND hz.party_id = p_contact_id -- The contact id
1244: AND hr.object_type = 'ORGANIZATION'
1241: hz_relationships hr
1242: WHERE hr.object_id = p_party_id -- The party being passsed
1243: AND hz.party_id = p_contact_id -- The contact id
1244: AND hr.object_type = 'ORGANIZATION'
1245: AND hr.object_table_name = 'HZ_PARTIES'
1246: AND hr.subject_type = 'PERSON'
1247: AND ((hr.relationship_code = 'CONTACT_OF') OR (hr.relationship_code = 'EMPLOYEE_OF'))
1248: AND hz.party_id = hr.party_id;
1249: