APPS.IEX_OPI_PVT dependencies on HZ_PARTIES

Line 1990: l_party_id HZ_PARTIES.PARTY_ID%TYPE;

1986: l_iohv_rec iohv_rec_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);

Line 2814: l_ext_agncy_id HZ_PARTIES.PARTY_ID%TYPE;

2810: lx_msg_data VARCHAR2(2000);
2811:
2812: l_case_number OKL_OPEN_INT.CASE_NUMBER%TYPE;
2813: l_contract_id OKL_OPEN_INT.KHR_ID%TYPE;
2814: l_ext_agncy_id HZ_PARTIES.PARTY_ID%TYPE;
2815:
2816: l_contracts_recalled NUMBER := 0;
2817: l_rows_failed NUMBER := 0;
2818:

Line 2967: WHERE owner_table_name = 'HZ_PARTIES'

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'
2971: AND status = 'A';