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;