APPS.OKL_STRY_CALL_CO_PUB dependencies on HZ_PARTIES

Line 38: FROM HZ_PARTIES

34: x_email OUT NOCOPY VARCHAR2) IS
35:
36: CURSOR C_GET_ORG_EMAIL (p_PARTY_ID NUMBER) IS
37: SELECT email_address
38: FROM HZ_PARTIES
39: WHERE party_ID =p_party_ID;
40:
41: CURSOR C_GET_CONTACT_EMAIL (p_PARTY_ID NUMBER) IS
42: SELECT email_address

Line 380: -- is write to customer. the email is picked from the hz_parties

376:
377: --get vendor email address
378: -- get vendor_info
379: -- don't get vendor info if custom workflow
380: -- is write to customer. the email is picked from the hz_parties
381: --table and is already set in the attribute PARTY_EMAIL.
382:
383: if l_email is NULL THEN
384: get_vendor_info(p_case_number => l_case_number,