DBA Data[Home] [Help]

APPS.IGS_AS_PROD_DOC dependencies on IGS_AS_DOCPROC_STUP

Line 22: FROM igs_as_docproc_stup

18: -- Cursor to get the institution setup for documents.
19: --
20: CURSOR c_setup IS
21: SELECT 'X'
22: FROM igs_as_docproc_stup
23: WHERE trans_request_if_hold_ind = 'N';
24: --
25: -- Cursor to get the holds information for the student which has effect of blocking his transcript
26: --

Line 108: FROM igs_as_docproc_stup;

104:
105: -- To determine if there exists a Transcript Hold for the student.
106: CURSOR cur_hold_dlv_ind IS
107: SELECT trans_request_if_hold_ind, hold_deliv_ind
108: FROM igs_as_docproc_stup;
109: rec_cur_hold_dlv_ind cur_hold_dlv_ind%ROWTYPE;
110:
111: -- To determine if the student has a pending transcript hold.
112: --ijeddy, bug 3410409.