APPS.QP_PRICE_BOOK_PUB dependencies on HZ_PARTIES

Line 568: FROM hz_relationships rel, hz_parties party3,

564: INTO l_party_id_match
565: FROM dual
566: WHERE EXISTS (
567: SELECT 'x'
568: FROM hz_relationships rel, hz_parties party3,
569: hz_parties party4, hz_parties party5
570: WHERE rel.party_id = party5.party_id
571: AND party5.party_type = 'PARTY_RELATIONSHIP'
572: AND party5.status = 'A'

Line 569: hz_parties party4, hz_parties party5

565: FROM dual
566: WHERE EXISTS (
567: SELECT 'x'
568: FROM hz_relationships rel, hz_parties party3,
569: hz_parties party4, hz_parties party5
570: WHERE rel.party_id = party5.party_id
571: AND party5.party_type = 'PARTY_RELATIONSHIP'
572: AND party5.status = 'A'
573: AND trunc(rel.start_date) <= trunc(sysdate)

Line 581: AND rel.subject_table_name = 'HZ_PARTIES'

577: AND party3.status = 'A'
578: AND rel.object_id = party4.party_id
579: AND party4.party_type = 'ORGANIZATION'
580: AND party4.status = 'A'
581: AND rel.subject_table_name = 'HZ_PARTIES'
582: AND rel.object_table_name = 'HZ_PARTIES'
583: AND rel.relationship_id IN
584: (SELECT party_relationship_id
585: FROM hz_org_contacts org_con

Line 582: AND rel.object_table_name = 'HZ_PARTIES'

578: AND rel.object_id = party4.party_id
579: AND party4.party_type = 'ORGANIZATION'
580: AND party4.status = 'A'
581: AND rel.subject_table_name = 'HZ_PARTIES'
582: AND rel.object_table_name = 'HZ_PARTIES'
583: AND rel.relationship_id IN
584: (SELECT party_relationship_id
585: FROM hz_org_contacts org_con
586: WHERE rel.relationship_id =

Line 609: FROM hz_parties

605: ELSE -- Internal User
606: BEGIN
607: SELECT 1
608: INTO l_count
609: FROM hz_parties
610: WHERE party_id = p_customer_id
611: AND rownum = 1;
612: EXCEPTION
613: WHEN OTHERS THEN