DBA Data[Home] [Help]

APPS.IGS_EN_ELGBL_PERSON dependencies on HZ_PARTIES

Line 387: CURSOR c_holds ( cp_person_id hz_parties.party_id%TYPE ) IS

383: --
384: -- cursor to fecth all the holds of the student which has the hold effect of Deny all
385: -- enrolment activity
386: --
387: CURSOR c_holds ( cp_person_id hz_parties.party_id%TYPE ) IS
388: SELECT ppe.person_id,
389: ppe.encumbrance_type,
390: peff.pee_start_dt hold_start_dt,
391: peff.expiry_dt