DBA Data[Home] [Help]

APPS.GHR_PAY_CALC dependencies on GHR_PA_REQUESTS

Line 47: ,first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE

43: ,noa_family_code ghr_families.noa_family_code%TYPE
44: ,noa_code ghr_nature_of_actions.code%TYPE
45: ,second_noa_code ghr_nature_of_actions.code%TYPE
46: --GPPA Update46
47: ,first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE
48: ,effective_date DATE
49: ,pay_rate_determinant VARCHAR2(30)
50: ,pay_plan VARCHAR2(30)
51: ,grade_or_level VARCHAR2(60)

Line 151: ,p_prd IN ghr_pa_requests.pay_rate_determinant%type

147: RETURN NUMBER;
148: --
149: FUNCTION get_open_pay_range (p_position_id IN hr_all_positions_f.position_id%TYPE
150: ,p_person_id IN per_all_people_f.person_id%type
151: ,p_prd IN ghr_pa_requests.pay_rate_determinant%type
152: ,p_pa_request_id IN ghr_pa_requests.pa_request_id%type
153: ,p_effective_date IN date)
154:
155: RETURN BOOLEAN;

Line 152: ,p_pa_request_id IN ghr_pa_requests.pa_request_id%type

148: --
149: FUNCTION get_open_pay_range (p_position_id IN hr_all_positions_f.position_id%TYPE
150: ,p_person_id IN per_all_people_f.person_id%type
151: ,p_prd IN ghr_pa_requests.pay_rate_determinant%type
152: ,p_pa_request_id IN ghr_pa_requests.pa_request_id%type
153: ,p_effective_date IN date)
154:
155: RETURN BOOLEAN;
156: --

Line 208: ,p_first_action_la_code1 IN ghr_pa_requests.first_action_la_code1%TYPE

204: ,p_position_id IN hr_all_positions_f.position_id%TYPE
205: ,p_noa_family_code IN ghr_families.noa_family_code%TYPE
206: ,p_noa_code IN ghr_nature_of_actions.code%TYPE
207: ,p_second_noa_code IN ghr_nature_of_actions.code%TYPE
208: ,p_first_action_la_code1 IN ghr_pa_requests.first_action_la_code1%TYPE
209: ,p_effective_date IN DATE
210: ,p_pay_rate_determinant IN VARCHAR2
211: ,p_pay_plan IN VARCHAR2
212: ,p_grade_or_level IN VARCHAR2

Line 291: p_effective_date IN ghr_pa_requests.effective_date%type,

287: ,p_effective_date IN date)
288: RETURN VARCHAR2;
289:
290: FUNCTION get_pay_basis(
291: p_effective_date IN ghr_pa_requests.effective_date%type,
292: p_pa_request_id IN ghr_pa_requests.pa_request_id%type,
293: p_person_id IN ghr_pa_requests.person_id%type
294: ) RETURN ghr_pa_requests.from_pay_basis%type;
295:

Line 292: p_pa_request_id IN ghr_pa_requests.pa_request_id%type,

288: RETURN VARCHAR2;
289:
290: FUNCTION get_pay_basis(
291: p_effective_date IN ghr_pa_requests.effective_date%type,
292: p_pa_request_id IN ghr_pa_requests.pa_request_id%type,
293: p_person_id IN ghr_pa_requests.person_id%type
294: ) RETURN ghr_pa_requests.from_pay_basis%type;
295:
296: PROCEDURE get_locality_894_itpay

Line 293: p_person_id IN ghr_pa_requests.person_id%type

289:
290: FUNCTION get_pay_basis(
291: p_effective_date IN ghr_pa_requests.effective_date%type,
292: p_pa_request_id IN ghr_pa_requests.pa_request_id%type,
293: p_person_id IN ghr_pa_requests.person_id%type
294: ) RETURN ghr_pa_requests.from_pay_basis%type;
295:
296: PROCEDURE get_locality_894_itpay
297: (p_pay_calc_data IN ghr_pay_calc.pay_calc_in_rec_type

Line 294: ) RETURN ghr_pa_requests.from_pay_basis%type;

290: FUNCTION get_pay_basis(
291: p_effective_date IN ghr_pa_requests.effective_date%type,
292: p_pa_request_id IN ghr_pa_requests.pa_request_id%type,
293: p_person_id IN ghr_pa_requests.person_id%type
294: ) RETURN ghr_pa_requests.from_pay_basis%type;
295:
296: PROCEDURE get_locality_894_itpay
297: (p_pay_calc_data IN ghr_pay_calc.pay_calc_in_rec_type
298: ,p_retained_grade IN ghr_pay_calc.retained_grade_rec_type

Line 340: ,p_prd IN ghr_pa_requests.pay_rate_determinant%type

336: ,p_effective_date IN DATE
337: ,p_basic_pay IN NUMBER
338: ,p_adj_basic_pay IN NUMBER
339: ,p_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
340: ,p_prd IN ghr_pa_requests.pay_rate_determinant%type
341: ,p_pay_basis IN VARCHAR2
342: ,p_person_id IN per_people_f.person_id%TYPE
343: ,p_award_amount OUT NOCOPY NUMBER
344: ,p_award_salary OUT NOCOPY NUMBER