APPS.CS_WF_EVENT_PKG dependencies on HZ_PARTIES

Line 650: FROM HZ_PARTIES P,

646: */
647: --Padmanabha Rao Modified the cursor for bug 5730498.
648: /* CURSOR l_sel_party_name_csr IS
649: SELECT P.PARTY_NAME
650: FROM HZ_PARTIES P,
651: CS_HZ_SR_CONTACT_POINTS C
652: WHERE P.PARTY_ID = l_contact_party_id AND C.CONTACT_TYPE <> 'EMPLOYEE' AND C.PARTY_ID= P.PARTY_ID
653: UNION
654: SELECT P.FULL_NAME

Line 667: FROM HZ_PARTIES p, cs_hz_sr_contact_points c

663: --Padmanabha Rao commented below cursor for bug 5730498.
664: /*
665: CURSOR l_sel_party_name_csr IS
666: SELECT p.PARTY_NAME
667: FROM HZ_PARTIES p, cs_hz_sr_contact_points c
668: WHERE p.PARTY_ID = c.party_id and
669: c.contact_type <> 'EMPLOYEE' and c.party_id=l_contact_party_id
670: UNION
671: select p.full_name

Line 692: , HZ_PARTIES P

688:
689: CURSOR l_sel_party_name_csr_non_emp IS
690: SELECT /*+ ORDERED */ P.PARTY_NAME
691: FROM CS_HZ_SR_CONTACT_POINTS C
692: , HZ_PARTIES P
693: WHERE C.PARTY_ID = l_contact_party_id
694: AND C.CONTACT_TYPE <> 'EMPLOYEE'
695: AND C.PARTY_ID= P.PARTY_ID
696: AND ROWNUM <= 1;