APPS.OZF_SETTLEMENT_DOC_PVT dependencies on HZ_PARTIES

Line 1197: FROM hz_parties party,

1193: l_claim_rec OZF_CLAIM_PVT.claim_Rec_Type;
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;

Line 1201: l_customer_name hz_parties.party_name%TYPE;

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:
1203: l_need_to_create VARCHAR2(1);
1204: l_claim_history_id NUMBER;
1205:

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