APPS.OZF_SETTLEMENT_DOC_PVT dependencies on HZ_CUST_ACCOUNTS

Line 963: hz_cust_accounts_all cust

959:
960: CURSOR csr_customer_name(cv_cust_account_id IN NUMBER) IS
961: SELECT party_name
962: FROM hz_parties party,
963: hz_cust_accounts_all cust
964: WHERE party.party_id = cust.party_id
965: AND cust.cust_account_id = cv_cust_account_id;
966: l_customer_name hz_parties.party_name%TYPE;
967:

Line 4621: FROM HZ_CUST_ACCOUNTS CA, HZ_PARTIES PARTY

4617: AND lookup_code = p_lkup_code;
4618:
4619: CURSOR csr_customer_name(p_cust_act_id IN NUMBER) IS
4620: SELECT SUBSTRB(PARTY.PARTY_NAME,1,50) NAME
4621: FROM HZ_CUST_ACCOUNTS CA, HZ_PARTIES PARTY
4622: WHERE CA.party_id = party.party_id
4623: AND CA.CUST_ACCOUNT_ID = p_cust_act_id;
4624:
4625: CURSOR csr_claim_type_name(p_claim_type_id IN NUMBER) IS