[Home] [Help]
PACKAGE: APPS.PAY_PAYFV_ELEMENT_ENTRIES_PKG
Source
1 package PAY_PAYFV_ELEMENT_ENTRIES_PKG AUTHID CURRENT_USER as
2 /* $Header: payfvele.pkh 115.2 2003/01/16 13:08:15 adhunter 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_ENTRIES
12 Purpose
13 To return non-id table information where needed to enhance the
14 performance of the view.
15 History
16 115.0 15-Jan-2001 J.Tomkins Created
17 115.1 15-Jan-2001 J.Tomkins Added Header Information.
18 */
19 --------------------------------------------------------------------------------
20 FUNCTION get_job (p_job_id IN NUMBER) RETURN VARCHAR2;
21 --------------------------------------------------------------------------------
22 FUNCTION get_position (p_pos_id IN NUMBER) RETURN VARCHAR2;
23 --------------------------------------------------------------------------------
24 FUNCTION get_grade (p_grade_id IN NUMBER) RETURN VARCHAR2;
25 --------------------------------------------------------------------------------
26 FUNCTION get_location (p_loc_id IN NUMBER) RETURN VARCHAR2;
27 --------------------------------------------------------------------------------
28 FUNCTION get_pay_basis (p_pay_id IN NUMBER) RETURN VARCHAR2;
29 --------------------------------------------------------------------------------
30 FUNCTION get_payroll (p_payroll_id IN NUMBER) RETURN VARCHAR2;
31 --------------------------------------------------------------------------------
32 END PAY_PAYFV_ELEMENT_ENTRIES_PKG;