APPS.OKS_CT_EVENTS_WFA dependencies on HZ_PARTIES

Line 298: --Replaced RA_CUSTOMERS.CUSTOMER_NAME%TYPE with HZ_PARTIES.PARTY_NAME%TYPE as RA_CUSTOMERS is obsoleted.

294: l_customer_id NUMBER;
295: --NPALEPU
296: --09-AUG-2005
297: --TCA Project
298: --Replaced RA_CUSTOMERS.CUSTOMER_NAME%TYPE with HZ_PARTIES.PARTY_NAME%TYPE as RA_CUSTOMERS is obsoleted.
299: /*l_customer_name RA_CUSTOMERS.CUSTOMER_NAME%TYPE; */
300: l_customer_name HZ_PARTIES.PARTY_NAME%TYPE;
301: --END NPALEPU
302: l_request_id NUMBER;

Line 300: l_customer_name HZ_PARTIES.PARTY_NAME%TYPE;

296: --09-AUG-2005
297: --TCA Project
298: --Replaced RA_CUSTOMERS.CUSTOMER_NAME%TYPE with HZ_PARTIES.PARTY_NAME%TYPE as RA_CUSTOMERS is obsoleted.
299: /*l_customer_name RA_CUSTOMERS.CUSTOMER_NAME%TYPE; */
300: l_customer_name HZ_PARTIES.PARTY_NAME%TYPE;
301: --END NPALEPU
302: l_request_id NUMBER;
303: l_request_number CS_INCIDENTS_V.INCIDENT_NUMBER%TYPE;
304: l_request_summary CS_INCIDENTS_V.SUMMARY%TYPE;

Line 342: from csc_hz_parties_v chpv,

338: chcpv.contact_point_id contact_point_id,
339: chcpv.CONTACT_POINT_TYPE CONTACT_POINT_TYPE,
340: chcpv.PRIMARY_FLAG PRIMARY_FLAG,
341: chcpv.party_type party_type
342: from csc_hz_parties_v chpv,
343: csc_hz_contact_points_v chcpv
344: where obj_party_type = 'ORGANIZATION'
345: and object_id = (select object1_id1 from okc_k_party_roles_v
346: where jtot_object1_code = 'OKX_PARTY'

Line 362: from csc_hz_parties_v chpv,

358: chcpv.CONTACT_POINT_TYPE CONTACT_POINT_TYPE,
359: chcpv.PRIMARY_FLAG PRIMARY_FLAG,
360: chcpv.party_type party_type,
361: chpv.sub_status
362: from csc_hz_parties_v chpv,
363: csc_hz_contact_points_v chcpv,
364: hz_relationships r
365: where chpv.obj_party_type = 'ORGANIZATION'
366: and chpv.object_id = (select object1_id1 from okc_k_party_roles_v