APPS.OZF_CLAIM_ACCRUAL_PVT dependencies on HZ_PARTIES

Line 1818: , hz_parties party

1814:
1815: CURSOR csr_cust_name(cv_cust_account_id IN NUMBER) IS
1816: SELECT CONCAT(CONCAT(party.party_name, ' ('), CONCAT(ca.account_number, ') '))
1817: FROM hz_cust_accounts ca
1818: , hz_parties party
1819: WHERE ca.party_id = party.party_id
1820: AND ca.cust_account_id = cv_cust_account_id;
1821:
1822: --Added cursor for Bug 16301629 , to check if both vendor and vendor site is active

Line 5972: FROM hz_parties p, hz_cust_accounts c

5968: l_accrual_flag VARCHAR2(1):= p_accrual_flag;
5969:
5970: CURSOR csr_party_name(cv_cust_account_id IN NUMBER) IS
5971: SELECT p.party_name
5972: FROM hz_parties p, hz_cust_accounts c
5973: WHERE p.party_id = c.party_id
5974: AND c.cust_account_id = cv_cust_account_id;
5975:
5976: BEGIN

Line 6958: FROM hz_parties p

6954: WHERE claim_id = cv_claim_id;
6955:
6956: CURSOR csr_party_name(cv_cust_account_id IN NUMBER) IS
6957: SELECT p.party_name
6958: FROM hz_parties p
6959: , hz_cust_accounts c
6960: WHERE p.party_id = c.party_id
6961: AND c.cust_account_id = cv_cust_account_id;
6962:

Line 7447: FROM hz_parties p

7443: WHERE claim_id = cv_claim_id;
7444:
7445: CURSOR csr_party_name(cv_cust_account_id IN NUMBER) IS
7446: SELECT p.party_name
7447: FROM hz_parties p
7448: , hz_cust_accounts c
7449: WHERE p.party_id = c.party_id
7450: AND c.cust_account_id = cv_cust_account_id;
7451: