APPS.GHR_PC_BASIC_PAY dependencies on GHR_PA_REQUESTS

Line 26: FROM ghr_pa_requests

22: l_noa_code ghr_nature_of_actions.code%type;
23:
24: CURSOR cur_par IS
25: SELECT first_noa_code,second_noa_code
26: FROM ghr_pa_requests
27: WHERE pa_request_id = p_pa_request_id;
28:
29: CURSOR cur_temp_step IS
30: SELECT rei_information3 temp_step

Line 2389: ghr_pa_requests_pkg.get_lookup_meaning(800,'GHR_US_PAY_BASIS'

2385: -- It could be either the position pay basis or the retained pay basis as to why we couldn't
2386: -- calculate
2387: IF p_pay_calc_data.pay_basis NOT IN ('PA','PH','BW') THEN
2388: hr_utility.set_message_token('PAY_BASIS',
2389: ghr_pa_requests_pkg.get_lookup_meaning(800,'GHR_US_PAY_BASIS'
2390: ,p_pay_calc_data.pay_basis));
2391: ELSE
2392: hr_utility.set_message_token('PAY_BASIS',
2393: ghr_pa_requests_pkg.get_lookup_meaning(800,'GHR_US_PAY_BASIS'

Line 2393: ghr_pa_requests_pkg.get_lookup_meaning(800,'GHR_US_PAY_BASIS'

2389: ghr_pa_requests_pkg.get_lookup_meaning(800,'GHR_US_PAY_BASIS'
2390: ,p_pay_calc_data.pay_basis));
2391: ELSE
2392: hr_utility.set_message_token('PAY_BASIS',
2393: ghr_pa_requests_pkg.get_lookup_meaning(800,'GHR_US_PAY_BASIS'
2394: ,l_pay_basis));
2395: END IF;
2396: raise ghr_pay_calc.unable_to_calculate;
2397: END IF;

Line 2742: p_eff_Date ghr_pa_requests.effective_date%TYPE)

2738: stp_5 NUMBER;
2739: l_basic_pay NUMBER;
2740:
2741: CURSOR cur_get_pos_org(p_pos_id per_positions.position_id%TYPE,
2742: p_eff_Date ghr_pa_requests.effective_date%TYPE)
2743: IS
2744: SELECT ORGANIZATION_ID FROM HR_POSITIONS_F
2745: WHERE position_id=p_pos_id
2746: AND p_eff_date between effective_start_Date and effective_end_date;