APPS.CS_WF_EVENT_PKG dependencies on HZ_PARTIES

Line 369: FROM HZ_PARTIES P,

365: */
366: --Padmanabha Rao Modified the cursor for bug 5730498.
367: CURSOR l_sel_party_name_csr IS
368: SELECT P.PARTY_NAME
369: FROM HZ_PARTIES P,
370: CS_HZ_SR_CONTACT_POINTS C
371: WHERE P.PARTY_ID = l_contact_party_id AND C.CONTACT_TYPE <> 'EMPLOYEE' AND C.PARTY_ID= P.PARTY_ID
372: UNION
373: SELECT P.FULL_NAME

Line 386: FROM HZ_PARTIES p, cs_hz_sr_contact_points c

382: --Padmanabha Rao commented below cursor for bug 5730498.
383: /*
384: CURSOR l_sel_party_name_csr IS
385: SELECT p.PARTY_NAME
386: FROM HZ_PARTIES p, cs_hz_sr_contact_points c
387: WHERE p.PARTY_ID = c.party_id and
388: c.contact_type <> 'EMPLOYEE' and c.party_id=l_contact_party_id
389: UNION
390: select p.full_name