277: WHERE payroll_action_id=cp_payroll_action_id;
278: --
279: CURSOR c_get_accruals(cp_cost_type IN VARCHAR2) IS
280: SELECT nvl(hr_general.decode_lookup('PAY_PAYRPCBR',cp_cost_type),' ')
281: FROM dual;
282: --
283:
284: /************************************************************
285: ** Cursor returns the session id **
286: *************************************************************/
287: --
288: CURSOR c_get_session_id IS
289: SELECT userenv('sessionid')
290: FROM dual;
291:
292: /************************************************************
293: ** Cursor returns payroll/gre totals **
294: ************************************************************/