APPS.IEX_OPI_PVT dependencies on HZ_CONTACT_POINTS

Line 1991: l_email HZ_CONTACT_POINTS.EMAIL_ADDRESS%TYPE;

1987:
1988: l_case_number OKL_OPEN_INT.CASE_NUMBER%TYPE;
1989: l_contract_id OKL_OPEN_INT.KHR_ID%TYPE;
1990: l_party_id HZ_PARTIES.PARTY_ID%TYPE;
1991: l_email HZ_CONTACT_POINTS.EMAIL_ADDRESS%TYPE;
1992: l_subject VARCHAR2(2000);
1993: l_content_id JTF_AMV_ITEMS_B.ITEM_ID%TYPE;
1994: l_from VARCHAR2(2000);
1995: l_agent_id NUMBER;

Line 2586: l_email HZ_CONTACT_POINTS.EMAIL_ADDRESS%TYPE;

2582:
2583: l_case_number OKL_OPEN_INT.CASE_NUMBER%TYPE;
2584: l_contract_id OKL_OPEN_INT.KHR_ID%TYPE;
2585: l_ext_agncy_id IEX_OPEN_INT_HST.EXT_AGNCY_ID%TYPE;
2586: l_email HZ_CONTACT_POINTS.EMAIL_ADDRESS%TYPE;
2587: l_subject VARCHAR2(2000);
2588: l_content_id JTF_AMV_ITEMS_B.ITEM_ID%TYPE;
2589: l_from VARCHAR2(2000);
2590: l_agent_id NUMBER;

Line 2966: FROM hz_contact_points

2962: x_return_status OUT NOCOPY VARCHAR2) AS
2963:
2964: CURSOR l_prty_email_csr(cp_party_id IN NUMBER) IS
2965: SELECT email_address
2966: FROM hz_contact_points
2967: WHERE owner_table_name = 'HZ_PARTIES'
2968: AND owner_table_id = cp_party_id
2969: AND contact_point_type = 'EMAIL'
2970: AND primary_flag = 'Y'

Line 2974: l_email HZ_CONTACT_POINTS.EMAIL_ADDRESS%TYPE;

2970: AND primary_flag = 'Y'
2971: AND status = 'A';
2972:
2973: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2974: l_email HZ_CONTACT_POINTS.EMAIL_ADDRESS%TYPE;
2975: BEGIN
2976: OPEN l_prty_email_csr(p_party_id);
2977: FETCH l_prty_email_csr INTO
2978: l_email;