APPS.GHR_PC_BASIC_PAY dependencies on STANDARD

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

1302:
1303: IF l_pos_basic_pay IS NULL THEN
1304: -- For pay plan CA need to check it hasn't exceeded EX-04 (table 0000 step 00)
1305: IF l_pay_plan = 'CA' THEN
1306: IF l_ret_basic_pay > ghr_pay_calc.get_standard_pay_table_value('EX'
1307: ,'04'
1308: ,'00'
1309: ,p_pay_calc_data.effective_date) THEN
1310: hr_utility.set_message(8301, 'GHR_38587_NO_CALC_EXCEED_EX_IV');

Line 1336: ELSIF l_user_table_name = ghr_pay_calc.l_standard_table_name THEN

1332: l_user_table_name := ghr_pay_calc.get_user_table_name(l_user_table_id);
1333: IF p_pay_calc_data.pay_rate_determinant IN ('J','K','R','S','3') THEN
1334: IF l_pay_basis = 'PH' THEN
1335: p_prd := 0;
1336: ELSIF l_user_table_name = ghr_pay_calc.l_standard_table_name THEN
1337: p_prd := '0';
1338: ELSE
1339: p_prd := '6';
1340: END IF;

Line 1344: ELSIF l_user_table_name = ghr_pay_calc.l_standard_table_name THEN

1340: END IF;
1341: ELSIF p_pay_calc_data.pay_rate_determinant = 'U' THEN
1342: IF l_pay_basis = 'PH' THEN
1343: p_prd := 'B';
1344: ELSIF l_user_table_name = ghr_pay_calc.l_standard_table_name THEN
1345: p_prd := 'B';
1346: ELSE
1347: p_prd := 'F';
1348: END IF;

Line 1352: ELSIF l_user_table_name = ghr_pay_calc.l_standard_table_name THEN

1348: END IF;
1349: ELSIF p_pay_calc_data.pay_rate_determinant = 'V' THEN
1350: IF l_pay_basis = 'PH' THEN
1351: p_prd := 'A';
1352: ELSIF l_user_table_name = ghr_pay_calc.l_standard_table_name THEN
1353: p_prd := 'A';
1354: ELSE
1355: p_prd := 'E';
1356: END IF;

Line 1736: IF l_user_table_name = ghr_pay_calc.l_standard_table_name THEN

1732:
1733: p_basic_pay := nvl(l_basic_pay,0);
1734: p_PT_eff_start_date := l_PT_eff_start_date;
1735:
1736: IF l_user_table_name = ghr_pay_calc.l_standard_table_name THEN
1737: l_spl_basic_pay := ghr_pay_calc.get_standard_pay_table_value
1738: (l_pay_plan
1739: ,l_grade_or_level
1740: ,l_step_or_rate

Line 1737: l_spl_basic_pay := ghr_pay_calc.get_standard_pay_table_value

1733: p_basic_pay := nvl(l_basic_pay,0);
1734: p_PT_eff_start_date := l_PT_eff_start_date;
1735:
1736: IF l_user_table_name = ghr_pay_calc.l_standard_table_name THEN
1737: l_spl_basic_pay := ghr_pay_calc.get_standard_pay_table_value
1738: (l_pay_plan
1739: ,l_grade_or_level
1740: ,l_step_or_rate
1741: ,p_pay_calc_data.effective_date);

Line 1746: l_A := ghr_pay_calc.get_standard_pay_table_value

1742: l_spl_locality_adj := ROUND(l_spl_basic_pay * (NVL(l_adjustment_percentage,0)/100),0);
1743: l_spl_adj_basic_pay := (l_spl_basic_pay + l_spl_locality_adj);
1744: ELSE
1745: l_spl_basic_pay := nvl(l_basic_pay,0);
1746: l_A := ghr_pay_calc.get_standard_pay_table_value
1747: ('GS'
1748: ,l_grade_or_level
1749: ,l_step_or_rate
1750: ,p_pay_calc_data.effective_date);

Line 1763: IF l_user_table_name = ghr_pay_calc.l_standard_table_name THEN

1759: -- Now do the comparison!
1760:
1761: IF (l_basic_pay > l_new_adj_basic_pay) OR
1762: (l_spl_adj_basic_pay > l_new_adj_basic_pay) THEN
1763: IF l_user_table_name = ghr_pay_calc.l_standard_table_name THEN
1764: p_prd := 0;
1765: ELSE
1766: p_prd := 6;
1767: END IF;

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

1796: p_prd := 0;
1797: l_new_adj_basic_pay := l_new_std_relative_rate;
1798: --------- l_locality_adj := l_new_adj_basic_pay - l_basic_pay;
1799: ELSIF (l_basic_pay > l_new_adj_basic_pay) AND
1800: (l_user_table_name <> ghr_pay_calc.l_standard_table_name) THEN
1801: p_prd := 6;
1802: l_new_adj_basic_pay := l_basic_pay;
1803: ------------- l_locality_adj := 0;
1804: END IF;

Line 2802: l_new_non_perfagn_max := ghr_pay_calc.get_standard_pay_table_value('EX'

2798: p_business_group_id => l_business_group_id,
2799: p_effective_date => l_effective_date);
2800:
2801: IF NOT(ghr_pay_caps.perf_certified(l_agency_subele_code,l_org_id, l_pay_plan, l_effective_date)) THEN
2802: l_new_non_perfagn_max := ghr_pay_calc.get_standard_pay_table_value('EX'
2803: ,'03'
2804: ,'00'
2805: ,l_effective_date);
2806: l_old_non_perfagn_max := ghr_pay_calc.get_standard_pay_table_value('EX'

Line 2806: l_old_non_perfagn_max := ghr_pay_calc.get_standard_pay_table_value('EX'

2802: l_new_non_perfagn_max := ghr_pay_calc.get_standard_pay_table_value('EX'
2803: ,'03'
2804: ,'00'
2805: ,l_effective_date);
2806: l_old_non_perfagn_max := ghr_pay_calc.get_standard_pay_table_value('EX'
2807: ,'03'
2808: ,'00'
2809: ,l_effective_date-1);
2810: l_new_rangeval_max := l_new_non_perfagn_max;