DBA Data[Home] [Help]

APPS.IGS_EN_ELGBL_PERSON dependencies on IGS_PE_PERSENC_EFFCT

Line 146: igs_pe_persenc_effct peff

142: ppe.encumbrance_type,
143: peff.pee_start_dt hold_start_dt,
144: peff.expiry_dt
145: FROM igs_pe_pers_encumb ppe,
146: igs_pe_persenc_effct peff
147: WHERE ppe.person_id = peff.person_id
148: AND ppe.encumbrance_type = peff.encumbrance_type
149: AND ppe.start_dt=peff.pen_start_dt
150: AND peff.s_encmb_effect_type = 'DENY_EACT'

Line 393: IGS_PE_PERSENC_EFFCT peff

389: ppe.encumbrance_type,
390: peff.pee_start_dt hold_start_dt,
391: peff.expiry_dt
392: FROM igs_pe_pers_encumb ppe,
393: IGS_PE_PERSENC_EFFCT peff
394: WHERE ppe.encumbrance_type = peff.encumbrance_type
395: AND ppe.start_dt=peff.pen_start_dt
396: AND s_encmb_effect_type in ('SUS_SRVC','RVK_SRVC')
397: AND ppe.person_id = cp_person_id;