APPS.OZF_SETTLEMENT_DOC_PVT dependencies on HZ_CUST_ACCOUNTS

Line 1198: hz_cust_accounts_all cust

1194:
1195: CURSOR csr_customer_name(cv_cust_account_id IN NUMBER) IS
1196: SELECT party_name
1197: FROM hz_parties party,
1198: hz_cust_accounts_all cust
1199: WHERE party.party_id = cust.party_id
1200: AND cust.cust_account_id = cv_cust_account_id;
1201: l_customer_name hz_parties.party_name%TYPE;
1202:

Line 2374: from ozf_claims_all claim, hz_cust_accounts cust

2370: claim.deduction_attribute1 ClaimDedAttr13,
2371: claim.deduction_attribute1 ClaimDedAttr14,
2372: claim.deduction_attribute1 ClaimDedAttr15,
2373: claim.org_id
2374: from ozf_claims_all claim, hz_cust_accounts cust
2375: Where
2376: claim.cust_account_id = cust.cust_account_id AND
2377: claim.claim_id = ' || l_claim_rec.claim_id);
2378:

Line 5110: FROM HZ_CUST_ACCOUNTS CA, HZ_PARTIES PARTY

5106: AND lookup_code = p_lkup_code;
5107:
5108: CURSOR csr_customer_name(p_cust_act_id IN NUMBER) IS
5109: SELECT SUBSTRB(PARTY.PARTY_NAME,1,50) NAME
5110: FROM HZ_CUST_ACCOUNTS CA, HZ_PARTIES PARTY
5111: WHERE CA.party_id = party.party_id
5112: AND CA.CUST_ACCOUNT_ID = p_cust_act_id;
5113:
5114: CURSOR csr_claim_type_name(p_claim_type_id IN NUMBER) IS