APPS.OKC_REP_QA_CHECK_PVT dependencies on HZ_PARTIES

Line 490: FROM hz_parties

486: l_party_name VARCHAR2(450); -- set to 360 in OKC_REP_IMP_PARTIES_T
487: -- For HZ_PARTY validation, using document "TCA Usage Guideline" Version 3.0
488: CURSOR partner_csr IS
489: SELECT party_name, status
490: FROM hz_parties
491: WHERE party_id = p_party_id
492: AND party_type = 'ORGANIZATION';
493: partner_rec partner_csr%ROWTYPE;
494:

Line 701: FROM hz_parties hz,

697: SELECT hz.party_name contact_name,
698: hr.status relationship_status,
699: hr.start_date start_date,
700: hr.end_date end_date
701: FROM hz_parties hz,
702: hz_relationships hr
703: WHERE hr.object_id = p_party_id -- The party being passsed
704: AND hz.party_id = p_contact_id -- The contact id
705: AND hr.object_type = 'ORGANIZATION'

Line 706: AND hr.object_table_name = 'HZ_PARTIES'

702: hz_relationships hr
703: WHERE hr.object_id = p_party_id -- The party being passsed
704: AND hz.party_id = p_contact_id -- The contact id
705: AND hr.object_type = 'ORGANIZATION'
706: AND hr.object_table_name = 'HZ_PARTIES'
707: AND hr.subject_type = 'PERSON'
708: AND ((hr.relationship_code = 'CONTACT_OF') OR (hr.relationship_code = 'EMPLOYEE_OF'))
709: AND hz.party_id = hr.party_id;
710: