DBA Data[Home] [Help]

APPS.GHR_PAY_CALC dependencies on STANDARD

Line 20: l_standard_table_name CONSTANT varchar2(80) := '0000 Oracle Federal Standard Pay Table (AL, ES, EX, GS, GG) No. 0000';

16: l_spl491_table_name CONSTANT varchar2(80) := '0491 Oracle Federal Special Rate Pay Table (GS) No. 0491';
17: -- FWFA Changes
18:
19: -- Global constants: (NB: Probably should have begun with with g - too late now as I assume people have used it!!1)
20: l_standard_table_name CONSTANT varchar2(80) := '0000 Oracle Federal Standard Pay Table (AL, ES, EX, GS, GG) No. 0000';
21:
22: --
23: -- This exception is used to indicate that we do not know how to calculate pay given the set of parameters
24: -- NOTE: It is not used if we should be able to calculate but just we had an error

Line 167: FUNCTION get_standard_pay_table_value (p_pay_plan IN VARCHAR2

163: ,p_PT_eff_start_date OUT NOCOPY DATE
164: ,p_PT_eff_end_date OUT NOCOPY DATE);
165: --
166: --
167: FUNCTION get_standard_pay_table_value (p_pay_plan IN VARCHAR2
168: ,p_grade_or_level IN VARCHAR2
169: ,p_step_or_rate IN VARCHAR2
170: ,p_effective_date IN DATE)
171: RETURN NUMBER;