APPS.OKL_STRY_CALL_CO_PUB dependencies on HZ_CONTACT_POINTS

Line 43: FROM HZ_CONTACT_POINTS

39: WHERE party_ID =p_party_ID;
40:
41: CURSOR C_GET_CONTACT_EMAIL (p_PARTY_ID NUMBER) IS
42: SELECT email_address
43: FROM HZ_CONTACT_POINTS
44: WHERE owner_table_ID = p_party_ID
45: AND Contact_point_type = 'EMAIL'
46: AND primary_flag = 'Y';
47:

Line 50: l_email HZ_CONTACT_POINTS.EMAIL_ADDRESS%TYPE;

46: AND primary_flag = 'Y';
47:
48:
49:
50: l_email HZ_CONTACT_POINTS.EMAIL_ADDRESS%TYPE;
51:
52:
53: BEGIN
54:

Line 280: l_email HZ_CONTACT_POINTS.EMAIL_ADDRESS%TYPE;

276: l_error VARCHAR2(32767);
277:
278: l_api_version CONSTANT NUMBER := 1;
279:
280: l_email HZ_CONTACT_POINTS.EMAIL_ADDRESS%TYPE;
281: l_subject VARCHAR2(2000);
282: l_from VARCHAR2(2000);
283: l_agent_id NUMBER := to_number(fnd_profile.value('OKL_FULFILLMENT_USER'));
284: l_request_id NUMBER;

Line 1371: l_email HZ_CONTACT_POINTS.EMAIL_ADDRESS%TYPE;

1367:
1368: l_status VARCHAR2(1);
1369: x_syndicate_flag VARCHAR2(1) DEFAULT 'N';
1370: l_party_id number;
1371: l_email HZ_CONTACT_POINTS.EMAIL_ADDRESS%TYPE;
1372:
1373: BEGIN
1374:
1375: if funcmode <> 'RUN' then