DBA Data[Home] [Help]

APPS.IGS_PS_WF_EVENT_HOOK_PKG dependencies on IGS_EN_SU_ATTEMPT

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