DBA Data[Home] [Help]

APPS.GHR_PAY_CALC dependencies on GHR_PA_REQUESTS

Line 50: ,first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE

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

Line 154: ,p_prd IN ghr_pa_requests.pay_rate_determinant%type

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

Line 155: ,p_pa_request_id IN ghr_pa_requests.pa_request_id%type

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

Line 211: ,p_first_action_la_code1 IN ghr_pa_requests.first_action_la_code1%TYPE

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

Line 294: p_effective_date IN ghr_pa_requests.effective_date%type,

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

Line 295: p_pa_request_id IN ghr_pa_requests.pa_request_id%type,

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

Line 296: p_person_id IN ghr_pa_requests.person_id%type

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

Line 297: ) RETURN ghr_pa_requests.from_pay_basis%type;

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

Line 343: ,p_prd IN ghr_pa_requests.pay_rate_determinant%type

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