APPS.IGS_EN_VAL_BULKRULE dependencies on IGS_PE_STD_TODO

Line 84: FROM IGS_PE_STD_TODO cst

80: END ;
81: DECLARE
82: CURSOR c_st IS
83: SELECT rowid,cst.*
84: FROM IGS_PE_STD_TODO cst
85: WHERE s_student_todo_type = 'UNIT-RULES' AND
86: logical_delete_dt IS NULL AND
87: NVL(todo_dt,TO_DATE('01/01/1980','DD/MM/YYYY')) <= SYSDATE
88: ORDER BY person_id asc

Line 153: IGS_PE_STD_TODO_pkg.update_row(

149: -- Logically remove the todo entries as they have been processed.
150: /* For the coloumn to be updated,modify the record variable value fetched */
151: v_st_rec.logical_delete_dt := SYSDATE;
152: /* Call server side TBH package procedure */
153: IGS_PE_STD_TODO_pkg.update_row(
154: X_ROWID => v_st_rec.ROWID,
155: X_PERSON_ID => v_st_rec.PERSON_ID,
156: X_S_STUDENT_TODO_TYPE => v_st_rec.S_STUDENT_TODO_TYPE,
157: X_SEQUENCE_NUMBER => v_st_rec.SEQUENCE_NUMBER,