87: IS
88: CURSOR c_is_workflow_enabled(p_set_of_books_id NUMBER)
89: IS
90: SELECT nvl(use_workflow_flag,'N')
91: FROM igi_itr_charge_setup
92: WHERE set_of_books_id = p_set_of_books_id;
93:
94: l_workflow_enabled VARCHAR2(1);
95:
100:
101: CURSOR c_get_timeout_days(p_set_of_books_id NUMBER)
102: IS
103: SELECT nvl(auto_approve_exceed_days,7)
104: FROM igi_itr_charge_setup
105: WHERE set_of_books_id = p_set_of_books_id;
106:
107: l_timeout_days NUMBER;
108: