1 package PAY_PAYFV_ELEMENT_TYPES_PKG AUTHID CURRENT_USER as
2 /* $Header: payfvetp.pkh 115.0 2003/01/13 14:18:22 scchakra noship $ */
3 -------------------------------------------------------------------------------
4 /*
5 +==============================================================================+
6 | Copyright (c) 2001 Oracle Corporation |
7 | Redwood Shores, California, USA |
8 | All rights reserved. |
9 +==============================================================================+
10 Name
11 Supporting functions for BIS view PAYFV_ELEMENT_TYPES
12 Purpose
13 To return non-id table information where needed to enhance the
14 performance of the view.
15 History
16
17 rem
18 rem Version Date Author Comment
19 rem -------+-----------+--------------+----------------------------------------
20 rem 115.0 13-JAN-2003 Scchakra Date Created
21 rem ==========================================================================
22 */
23 --------------------------------------------------------------------------------
24 FUNCTION get_applsys_user (p_user_id IN NUMBER) RETURN VARCHAR2;
25 --------------------------------------------------------------------------------
26 FUNCTION get_event_group_name (p_event_group_id IN NUMBER) RETURN VARCHAR2;
27 --------------------------------------------------------------------------------
28 END PAY_PAYFV_ELEMENT_TYPES_PKG;