APPS.CS_WF_EVENT_PKG dependencies on CS_HZ_SR_CONTACT_POINTS

Line 370: CS_HZ_SR_CONTACT_POINTS C

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

Line 378: FROM CS_HZ_SR_CONTACT_POINTS C

374: FROM PER_ALL_PEOPLE_F P
375: WHERE P.PERSON_ID = l_contact_party_id AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(P.EFFECTIVE_START_DATE, SYSDATE))
376: AND TRUNC(NVL(P.EFFECTIVE_END_DATE, SYSDATE))
377: AND EXISTS (SELECT 1
378: FROM CS_HZ_SR_CONTACT_POINTS C
379: WHERE C.CONTACT_TYPE = 'EMPLOYEE'
380: AND C.PARTY_ID = P.PERSON_ID) ;
381:
382: --Padmanabha Rao commented below cursor for bug 5730498.

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

Line 391: from per_all_people_f 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
391: from per_all_people_f p, cs_hz_sr_contact_points c
392: where p.person_id = c.party_id
393: and TRUNC(SYSDATE) BETWEEN TRUNC(NVL(p.effective_start_date, SYSDATE))
394: and TRUNC(NVL(p.effective_end_date, SYSDATE))
395: and c.contact_type = 'EMPLOYEE' and c.party_id=l_contact_party_id;