DBA Data[Home] [Help]

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 2345: ghr_pa_requests_pkg.get_lookup_meaning(800,'GHR_US_PAY_BASIS'

2341: -- It could be either the position pay basis or the retained pay basis as to why we couldn't
2342: -- calculate
2343: IF p_pay_calc_data.pay_basis NOT IN ('PA','PH','BW') THEN
2344: hr_utility.set_message_token('PAY_BASIS',
2345: ghr_pa_requests_pkg.get_lookup_meaning(800,'GHR_US_PAY_BASIS'
2346: ,p_pay_calc_data.pay_basis));
2347: ELSE
2348: hr_utility.set_message_token('PAY_BASIS',
2349: ghr_pa_requests_pkg.get_lookup_meaning(800,'GHR_US_PAY_BASIS'

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

2345: ghr_pa_requests_pkg.get_lookup_meaning(800,'GHR_US_PAY_BASIS'
2346: ,p_pay_calc_data.pay_basis));
2347: ELSE
2348: hr_utility.set_message_token('PAY_BASIS',
2349: ghr_pa_requests_pkg.get_lookup_meaning(800,'GHR_US_PAY_BASIS'
2350: ,l_pay_basis));
2351: END IF;
2352: raise ghr_pay_calc.unable_to_calculate;
2353: END IF;