APPS.OZF_CLAIM_ACCRUAL_PVT dependencies on HZ_PARTIES

Line 1532: , hz_parties party

1528:
1529: CURSOR csr_cust_name(cv_cust_account_id IN NUMBER) IS
1530: SELECT CONCAT(CONCAT(party.party_name, ' ('), CONCAT(ca.account_number, ') '))
1531: FROM hz_cust_accounts ca
1532: , hz_parties party
1533: WHERE ca.party_id = party.party_id
1534: AND ca.cust_account_id = cv_cust_account_id;
1535:
1536: l_cust_account_id number := p_cust_trade_profile.cust_account_id;

Line 4961: FROM hz_parties p, hz_cust_accounts c

4957: l_close_claim_flag VARCHAR2(1);
4958:
4959: CURSOR csr_party_name(cv_cust_account_id IN NUMBER) IS
4960: SELECT p.party_name
4961: FROM hz_parties p, hz_cust_accounts c
4962: WHERE p.party_id = c.party_id
4963: AND c.cust_account_id = cv_cust_account_id;
4964:
4965: BEGIN

Line 5881: FROM hz_parties p, hz_cust_accounts c

5877: WHERE claim_id = cv_claim_id;
5878:
5879: CURSOR csr_party_name(cv_cust_account_id IN NUMBER) IS
5880: SELECT p.party_name
5881: FROM hz_parties p, hz_cust_accounts c
5882: WHERE p.party_id = c.party_id
5883: AND c.cust_account_id = cv_cust_account_id;
5884:
5885: --Added for bug 7030415