DBA Data[Home] [Help]

APPS.GHR_PC_BASIC_PAY dependencies on PAY_USER_TABLES

Line 1073: l_user_table_name pay_user_tables.user_table_name%type;

1069: l_cur_pos_basic_pay NUMBER;
1070: --
1071: l_converted_increase NUMBER;
1072: --
1073: l_user_table_name pay_user_tables.user_table_name%type;
1074:
1075: --Bug 3180991
1076: l_old_user_table_id NUMBER;
1077: l_asg_ei_data per_assignment_extra_info%rowtype;

Line 1649: l_user_table_name pay_user_tables.user_table_name%type;

1645: ----l_cur_pos_basic_pay NUMBER;
1646: --
1647: ----l_converted_increase NUMBER;
1648: --
1649: l_user_table_name pay_user_tables.user_table_name%type;
1650: l_adjustment_percentage ghr_locality_pay_areas_f.adjustment_percentage%TYPE;
1651: l_spl_basic_pay NUMBER;
1652: l_spl_adj_basic_pay NUMBER;
1653: l_spl_locality_adj NUMBER;

Line 2376: ,p_user_table_id IN pay_user_tables.user_table_id%TYPE

2372: -- adjusted basic pay for employee in 'GM' pay plan and NOA 894 AC
2373:
2374: PROCEDURE get_894_GM_sp_basic_pay(p_grade_or_level IN VARCHAR2
2375: ,p_effective_date IN DATE
2376: ,p_user_table_id IN pay_user_tables.user_table_id%TYPE
2377: ,p_default_table_id IN NUMBER
2378: ,p_curr_basic_pay IN NUMBER
2379: ,p_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
2380: ,p_new_basic_pay OUT NOCOPY NUMBER

Line 2531: ,p_user_table_id IN pay_user_tables.user_table_id%TYPE

2527: -- adjusted basic pay for WGI employee in 'GM' pay plan AC
2528:
2529: PROCEDURE get_wgi_GM_sp_basic_pay(p_grade_or_level IN VARCHAR2
2530: ,p_effective_date IN DATE
2531: ,p_user_table_id IN pay_user_tables.user_table_id%TYPE
2532: ,p_default_table_id IN NUMBER
2533: ,p_curr_basic_pay IN NUMBER
2534: ,p_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
2535: ,p_new_basic_pay OUT NOCOPY NUMBER