DBA Data[Home] [Help]

APPS.GHR_PC_BASIC_PAY dependencies on STANDARD

Line 1289: IF l_ret_basic_pay > ghr_pay_calc.get_standard_pay_table_value('EX'

1285:
1286: IF l_pos_basic_pay IS NULL THEN
1287: -- For pay plan CA need to check it hasn't exceeded EX-04 (table 0000 step 00)
1288: IF l_pay_plan = 'CA' THEN
1289: IF l_ret_basic_pay > ghr_pay_calc.get_standard_pay_table_value('EX'
1290: ,'04'
1291: ,'00'
1292: ,p_pay_calc_data.effective_date) THEN
1293: hr_utility.set_message(8301, 'GHR_38587_NO_CALC_EXCEED_EX_IV');

Line 1319: ELSIF l_user_table_name = ghr_pay_calc.l_standard_table_name THEN

1315: l_user_table_name := ghr_pay_calc.get_user_table_name(l_user_table_id);
1316: IF p_pay_calc_data.pay_rate_determinant IN ('J','K','R','S','3') THEN
1317: IF l_pay_basis = 'PH' THEN
1318: p_prd := 0;
1319: ELSIF l_user_table_name = ghr_pay_calc.l_standard_table_name THEN
1320: p_prd := '0';
1321: ELSE
1322: p_prd := '6';
1323: END IF;

Line 1327: ELSIF l_user_table_name = ghr_pay_calc.l_standard_table_name THEN

1323: END IF;
1324: ELSIF p_pay_calc_data.pay_rate_determinant = 'U' THEN
1325: IF l_pay_basis = 'PH' THEN
1326: p_prd := 'B';
1327: ELSIF l_user_table_name = ghr_pay_calc.l_standard_table_name THEN
1328: p_prd := 'B';
1329: ELSE
1330: p_prd := 'F';
1331: END IF;

Line 1335: ELSIF l_user_table_name = ghr_pay_calc.l_standard_table_name THEN

1331: END IF;
1332: ELSIF p_pay_calc_data.pay_rate_determinant = 'V' THEN
1333: IF l_pay_basis = 'PH' THEN
1334: p_prd := 'A';
1335: ELSIF l_user_table_name = ghr_pay_calc.l_standard_table_name THEN
1336: p_prd := 'A';
1337: ELSE
1338: p_prd := 'E';
1339: END IF;

Line 1719: IF l_user_table_name = ghr_pay_calc.l_standard_table_name THEN

1715:
1716: p_basic_pay := nvl(l_basic_pay,0);
1717: p_PT_eff_start_date := l_PT_eff_start_date;
1718:
1719: IF l_user_table_name = ghr_pay_calc.l_standard_table_name THEN
1720: l_spl_basic_pay := ghr_pay_calc.get_standard_pay_table_value
1721: (l_pay_plan
1722: ,l_grade_or_level
1723: ,l_step_or_rate

Line 1720: l_spl_basic_pay := ghr_pay_calc.get_standard_pay_table_value

1716: p_basic_pay := nvl(l_basic_pay,0);
1717: p_PT_eff_start_date := l_PT_eff_start_date;
1718:
1719: IF l_user_table_name = ghr_pay_calc.l_standard_table_name THEN
1720: l_spl_basic_pay := ghr_pay_calc.get_standard_pay_table_value
1721: (l_pay_plan
1722: ,l_grade_or_level
1723: ,l_step_or_rate
1724: ,p_pay_calc_data.effective_date);

Line 1729: l_A := ghr_pay_calc.get_standard_pay_table_value

1725: l_spl_locality_adj := ROUND(l_spl_basic_pay * (NVL(l_adjustment_percentage,0)/100),0);
1726: l_spl_adj_basic_pay := (l_spl_basic_pay + l_spl_locality_adj);
1727: ELSE
1728: l_spl_basic_pay := nvl(l_basic_pay,0);
1729: l_A := ghr_pay_calc.get_standard_pay_table_value
1730: ('GS'
1731: ,l_grade_or_level
1732: ,l_step_or_rate
1733: ,p_pay_calc_data.effective_date);

Line 1746: IF l_user_table_name = ghr_pay_calc.l_standard_table_name THEN

1742: -- Now do the comparison!
1743:
1744: IF (l_basic_pay > l_new_adj_basic_pay) OR
1745: (l_spl_adj_basic_pay > l_new_adj_basic_pay) THEN
1746: IF l_user_table_name = ghr_pay_calc.l_standard_table_name THEN
1747: p_prd := 0;
1748: ELSE
1749: p_prd := 6;
1750: END IF;

Line 1783: (l_user_table_name <> ghr_pay_calc.l_standard_table_name) THEN

1779: p_prd := 0;
1780: l_new_adj_basic_pay := l_new_std_relative_rate;
1781: --------- l_locality_adj := l_new_adj_basic_pay - l_basic_pay;
1782: ELSIF (l_basic_pay > l_new_adj_basic_pay) AND
1783: (l_user_table_name <> ghr_pay_calc.l_standard_table_name) THEN
1784: p_prd := 6;
1785: l_new_adj_basic_pay := l_basic_pay;
1786: ------------- l_locality_adj := 0;
1787: END IF;

Line 1939: l_ig_pay_amount := ghr_pay_calc.get_standard_pay_table_value (p_pay_plan => l_pay_plan

1935: ,p_pay_calc_out_data.basic_pay
1936: ,l_dummy_date);
1937: --Begin Bug# 7557159
1938: ELSIF p_pay_calc_data.pay_rate_determinant IN ('S') AND l_pay_plan IN ('IG') THEN
1939: l_ig_pay_amount := ghr_pay_calc.get_standard_pay_table_value (p_pay_plan => l_pay_plan
1940: ,p_grade_or_level => '00'
1941: ,p_step_or_rate => '00'
1942: ,p_effective_date => p_pay_calc_data.effective_date);
1943: IF l_ig_pay_amount > p_pay_calc_data.current_basic_pay THEN