1 PACKAGE pay_gb_eas_scotland_functions AUTHID CURRENT_USER AS
2 /* $Header: pygbeasf.pkh 120.0.12010000.3 2009/12/24 13:09:25 krreddy ship $ */
3
4 FUNCTION get_current_freq(p_assignment_id IN NUMBER) RETURN NUMBER;
5
6 FUNCTION count_main_eas_entry(p_assignment_id IN NUMBER) RETURN NUMBER;
7
8 FUNCTION get_main_eas_pay_date(p_assignment_id IN NUMBER) RETURN DATE;
9
10 FUNCTION get_main_eas_freq(p_assignment_id IN NUMBER) RETURN NUMBER;
11
12 FUNCTION check_ref(p_assignment_id IN NUMBER, p_reference IN VARCHAR2) RETURN VARCHAR2;
13
14 FUNCTION get_main_initial_debt(p_assignment_id IN NUMBER) RETURN NUMBER;
15
16 FUNCTION get_main_fee(p_assignment_id IN NUMBER) RETURN NUMBER;
17
18 FUNCTION get_eas_value(p_table_name IN VARCHAR2, p_row_value IN VARCHAR2,
19 p_effective_date in DATE) RETURN NUMBER;
20
21 END pay_gb_eas_scotland_functions;