APPS.OZF_CLAIM_PVT dependencies on HZ_PARTIES

Line 436: , hz_parties p

432: CURSOR contact_id_csr(p_cust_account_id in number,
433: p_party_relationship_id in number) is
434: SELECT p.party_id -- ,p.party_name
435: FROM hz_relationships r -- Bug 4654753
436: , hz_parties p
437: , hz_cust_accounts c
438: WHERE r.subject_id = p.party_id
439: AND r.relationship_id = p_party_relationship_id -- Bug 4654753
440: AND r.object_id = c.party_id

Line 462: from hz_parties p

458: l_contact_id number;
459:
460: CURSOR contact_party_id_csr (p_contact_id in number) is
461: select p.party_id
462: from hz_parties p
463: , hz_cust_account_roles r
464: , hz_relationships rel
465: where r.cust_account_role_id = p_contact_id
466: and r.party_id = rel.party_id

Line 468: and SUBJECT_TABLE_NAME = 'HZ_PARTIES'

464: , hz_relationships rel
465: where r.cust_account_role_id = p_contact_id
466: and r.party_id = rel.party_id
467: and rel.subject_id = p.party_id
468: and SUBJECT_TABLE_NAME = 'HZ_PARTIES'
469: AND OBJECT_TABLE_NAME = 'HZ_PARTIES'
470: AND DIRECTIONAL_FLAG = 'F';
471:
472: BEGIN

Line 469: AND OBJECT_TABLE_NAME = 'HZ_PARTIES'

465: where r.cust_account_role_id = p_contact_id
466: and r.party_id = rel.party_id
467: and rel.subject_id = p.party_id
468: and SUBJECT_TABLE_NAME = 'HZ_PARTIES'
469: AND OBJECT_TABLE_NAME = 'HZ_PARTIES'
470: AND DIRECTIONAL_FLAG = 'F';
471:
472: BEGIN
473:

Line 763: FROM hz_parties

759: --WHERE CUST_ACCOUNT_ID = p_cust_account_id;
760:
761: CURSOR party_info_csr(p_party_id in number)is
762: SELECT category_code
763: FROM hz_parties
764: WHERE party_id = p_party_id;
765:
766: CURSOR cust_profile_csr(p_account_id in number,
767: p_site_use_id in number) is

Line 8384: FROM hz_parties p,

8380: CURSOR party_csr(p_cust_id in number,
8381: p_relation_type in varchar2,
8382: p_party_id in number) IS
8383: SELECT count(p.party_id)
8384: FROM hz_parties p,
8385: hz_relationships r,
8386: hz_cust_accounts c
8387: WHERE p.party_id = r.subject_id
8388: AND r.relationship_code = p_relation_type