APPS.IGS_PS_WF_EVENT_HOOK_PKG dependencies on HZ_PARTIES

Line 22: sommukhe 24-Jan-2006 Bug #4926548,replaced igs_pe_person with hz_parties and hz_person_profiles for inline cursors p_students and p_instructors

18:
19: Change History
20:
21: Who When What
22: sommukhe 24-Jan-2006 Bug #4926548,replaced igs_pe_person with hz_parties and hz_person_profiles for inline cursors p_students and p_instructors
23: sarakshi 12-Jan-2005 Bug#4926548, modified the select for the ref cursor p_unit_dtls such ath tit uses the base tables rather than the view IGS_PS_UNIT_OFR_OPT_V
24: ***************************************************************/
25:
26: BEGIN

Line 110: FROM igs_en_su_attempt a,hz_parties p,hz_person_profiles pp

106: a.unit_attempt_status,
107: p.party_number person_number,
108: p.email_address email_addr,
109: pp.person_name full_name
110: FROM igs_en_su_attempt a,hz_parties p,hz_person_profiles pp
111: WHERE a.UOO_ID=p_uoo_id
112: AND a.UNIT_ATTEMPT_STATUS IN ('ENROLLED','WAITLISTED')
113: AND a.person_id=p.party_id
114: AND p.party_id = pp.party_id AND

Line 129: FROM igs_en_su_attempt a,hz_parties p,hz_person_profiles pp

125: a.unit_attempt_status,
126: p.party_number person_number,
127: p.email_address email_addr,
128: pp.person_name full_name
129: FROM igs_en_su_attempt a,hz_parties p,hz_person_profiles pp
130: WHERE a.uoo_id=p_uoo_id
131: AND a.unit_attempt_status IN ('DROPPED','DISCONTIN')
132: AND a.person_id=p.party_id
133: AND p.party_id = pp.party_id AND

Line 146: FROM HZ_PARTIES P,HZ_PERSON_PROFILES PP

142: IF p_instructors%ISOPEN THEN
143: close p_instructors;
144: ELSE
145: OPEN p_instructors FOR SELECT P.PARTY_NUMBER PERSON_NUMBER,P.EMAIL_ADDRESS EMAIL_ADDR,PP.PERSON_NAME FULL_NAME
146: FROM HZ_PARTIES P,HZ_PERSON_PROFILES PP
147: WHERE P.PARTY_ID = l_instructor_id
148: AND P.PARTY_ID = PP.PARTY_ID AND
149: SYSDATE BETWEEN PP.EFFECTIVE_START_DATE AND
150: NVL(PP.EFFECTIVE_END_DATE,SYSDATE);