APPS.CS_WF_EVENT_PKG dependencies on CS_HZ_SR_CONTACT_POINTS

Line 651: CS_HZ_SR_CONTACT_POINTS C

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
655: FROM PER_ALL_PEOPLE_F P

Line 659: FROM CS_HZ_SR_CONTACT_POINTS C

655: FROM PER_ALL_PEOPLE_F P
656: WHERE P.PERSON_ID = l_contact_party_id AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(P.EFFECTIVE_START_DATE, SYSDATE))
657: AND TRUNC(NVL(P.EFFECTIVE_END_DATE, SYSDATE))
658: AND EXISTS (SELECT 1
659: FROM CS_HZ_SR_CONTACT_POINTS C
660: WHERE C.CONTACT_TYPE = 'EMPLOYEE'
661: AND C.PARTY_ID = P.PERSON_ID) ;
662:
663: --Padmanabha Rao commented below cursor for bug 5730498.

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 672: from per_all_people_f 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
672: from per_all_people_f p, cs_hz_sr_contact_points c
673: where p.person_id = c.party_id
674: and TRUNC(SYSDATE) BETWEEN TRUNC(NVL(p.effective_start_date, SYSDATE))
675: and TRUNC(NVL(p.effective_end_date, SYSDATE))
676: and c.contact_type = 'EMPLOYEE' and c.party_id=l_contact_party_id;

Line 691: FROM CS_HZ_SR_CONTACT_POINTS C

687: --Bkanimoz replaced the above cursor with the below 2 cursors for bug 9790566
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

Line 704: FROM CS_HZ_SR_CONTACT_POINTS C

700: FROM PER_ALL_PEOPLE_F P
701: WHERE P.PERSON_ID = l_contact_party_id
702: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(P.EFFECTIVE_START_DATE, SYSDATE)) AND TRUNC(NVL(P.EFFECTIVE_END_DATE, SYSDATE))
703: AND EXISTS (SELECT 1
704: FROM CS_HZ_SR_CONTACT_POINTS C
705: WHERE C.CONTACT_TYPE = 'EMPLOYEE'
706: AND C.PARTY_ID = P.PERSON_ID
707: );
708: --end bug 9790566