[Home] [Help]
1086: l_cur_pos_basic_pay NUMBER;
1087: --
1088: l_converted_increase NUMBER;
1089: --
1090: l_user_table_name pay_user_tables.user_table_name%type;
1091:
1092: --Bug 3180991
1093: l_old_user_table_id NUMBER;
1094: l_asg_ei_data per_assignment_extra_info%rowtype;
1662: ----l_cur_pos_basic_pay NUMBER;
1663: --
1664: ----l_converted_increase NUMBER;
1665: --
1666: l_user_table_name pay_user_tables.user_table_name%type;
1667: l_adjustment_percentage ghr_locality_pay_areas_f.adjustment_percentage%TYPE;
1668: l_spl_basic_pay NUMBER;
1669: l_spl_adj_basic_pay NUMBER;
1670: l_spl_locality_adj NUMBER;
1854: --- Added for 5871233
1855: cursor chk_user_table(p_user_table_id in number)
1856: is
1857: SELECT 1
1858: FROM PAY_USER_TABLES
1859: WHERE USER_TABLE_ID = p_user_table_id
1860: AND USER_TABLE_NAME like '0000%';
1861:
1862: l_fws_flag VARCHAR2(5);
2416: -- adjusted basic pay for employee in 'GM' pay plan and NOA 894 AC
2417:
2418: PROCEDURE get_894_GM_sp_basic_pay(p_grade_or_level IN VARCHAR2
2419: ,p_effective_date IN DATE
2420: ,p_user_table_id IN pay_user_tables.user_table_id%TYPE
2421: ,p_default_table_id IN NUMBER
2422: ,p_curr_basic_pay IN NUMBER
2423: ,p_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
2424: ,p_new_basic_pay OUT NOCOPY NUMBER
2571: -- adjusted basic pay for WGI employee in 'GM' pay plan AC
2572:
2573: PROCEDURE get_wgi_GM_sp_basic_pay(p_grade_or_level IN VARCHAR2
2574: ,p_effective_date IN DATE
2575: ,p_user_table_id IN pay_user_tables.user_table_id%TYPE
2576: ,p_default_table_id IN NUMBER
2577: ,p_curr_basic_pay IN NUMBER
2578: ,p_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
2579: ,p_new_basic_pay OUT NOCOPY NUMBER