APPS.OZF_CLAIM_PVT dependencies on HZ_PARTIES

Line 383: , hz_parties p

379: CURSOR contact_id_csr(p_cust_account_id in number,
380: p_party_relationship_id in number) is
381: SELECT p.party_id -- ,p.party_name
382: FROM hz_relationships r -- Bug 4654753
383: , hz_parties p
384: , hz_cust_accounts c
385: WHERE r.subject_id = p.party_id
386: AND r.relationship_id = p_party_relationship_id -- Bug 4654753
387: AND r.object_id = c.party_id

Line 409: from hz_parties p

405: l_contact_id number;
406:
407: CURSOR contact_party_id_csr (p_contact_id in number) is
408: select p.party_id
409: from hz_parties p
410: , hz_cust_account_roles r
411: , hz_relationships rel
412: where r.cust_account_role_id = p_contact_id
413: and r.party_id = rel.party_id

Line 415: and SUBJECT_TABLE_NAME = 'HZ_PARTIES'

411: , hz_relationships rel
412: where r.cust_account_role_id = p_contact_id
413: and r.party_id = rel.party_id
414: and rel.subject_id = p.party_id
415: and SUBJECT_TABLE_NAME = 'HZ_PARTIES'
416: AND OBJECT_TABLE_NAME = 'HZ_PARTIES'
417: AND DIRECTIONAL_FLAG = 'F';
418:
419: BEGIN

Line 416: AND OBJECT_TABLE_NAME = 'HZ_PARTIES'

412: where r.cust_account_role_id = p_contact_id
413: and r.party_id = rel.party_id
414: and rel.subject_id = p.party_id
415: and SUBJECT_TABLE_NAME = 'HZ_PARTIES'
416: AND OBJECT_TABLE_NAME = 'HZ_PARTIES'
417: AND DIRECTIONAL_FLAG = 'F';
418:
419: BEGIN
420:

Line 710: FROM hz_parties

706: --WHERE CUST_ACCOUNT_ID = p_cust_account_id;
707:
708: CURSOR party_info_csr(p_party_id in number)is
709: SELECT category_code
710: FROM hz_parties
711: WHERE party_id = p_party_id;
712:
713: CURSOR cust_profile_csr(p_account_id in number,
714: p_site_use_id in number) is

Line 6731: FROM hz_parties p,

6727: CURSOR party_csr(p_cust_id in number,
6728: p_relation_type in varchar2,
6729: p_party_id in number) IS
6730: SELECT count(p.party_id)
6731: FROM hz_parties p,
6732: hz_relationships r,
6733: hz_cust_accounts c
6734: WHERE p.party_id = r.subject_id
6735: AND r.relationship_code = p_relation_type