APPS.IGS_AS_PROD_DOC dependencies on IGS_PE_PERSENC_EFFCT

Line 29: FROM igs_pe_persenc_effct

25: -- Cursor to get the holds information for the student which has effect of blocking his transcript
26: --
27: CURSOR c_hold IS
28: SELECT 'X'
29: FROM igs_pe_persenc_effct
30: WHERE person_id = p_person_id
31: AND s_encmb_effect_type IN ('TRANS_BLK','RVK_SRVC','SUS_SRVC','RESULT_BLK')
32: AND NVL (expiry_dt, SYSDATE) >= SYSDATE
33: AND pee_start_dt < SYSDATE

Line 116: FROM igs_pe_persenc_effct

112: --ijeddy, bug 3410409.
113: CURSOR cur_hold_eft (cp_person_id igs_as_chn_grd_req.person_id%TYPE,
114: cp_creation_date igs_as_ord_itm_int.creation_date%TYPE) IS
115: SELECT 'X'
116: FROM igs_pe_persenc_effct
117: WHERE person_id = cp_person_id AND
118: s_encmb_effect_type IN (cst_trans_blk,cst_trans_blk1,cst_trans_blk2,cst_trans_blk3) AND
119: expiry_dt IS NULL AND
120: TRUNC(pen_start_dt) <= TRUNC(cp_creation_date);