DBA Data[Home] [Help]

APPS.GHR_PAY_CALC dependencies on PER_PEOPLE_F

Line 219: (p_person_id IN per_people_f.person_id%TYPE

215:
216: --Bug#5132113 added new parameter p_open_range_out_basic_pay
217:
218: FUNCTION populate_in_rec_structure
219: (p_person_id IN per_people_f.person_id%TYPE
220: ,p_position_id IN hr_all_positions_f.position_id%TYPE
221: ,p_noa_family_code IN ghr_families.noa_family_code%TYPE
222: ,p_noa_code IN ghr_nature_of_actions.code%TYPE
223: ,p_second_noa_code IN ghr_nature_of_actions.code%TYPE

Line 1647: PROCEDURE main_pay_calc (p_person_id IN per_people_f.person_id%TYPE

1643: RAISE;
1644:
1645: END get_total_salary;
1646:
1647: PROCEDURE main_pay_calc (p_person_id IN per_people_f.person_id%TYPE
1648: ,p_position_id IN hr_all_positions_f.position_id%TYPE
1649: ,p_noa_family_code IN ghr_families.noa_family_code%TYPE
1650: ,p_noa_code IN ghr_nature_of_actions.code%TYPE
1651: ,p_second_noa_code IN ghr_nature_of_actions.code%TYPE

Line 1748: per_people_f per1

1744:
1745: cursor cur_ex_emp is
1746: select 1
1747: from per_person_types pet1,
1748: per_people_f per1
1749: where pet1.person_type_id = per1.person_type_id
1750: and per1.person_id = p_person_id
1751: and nvl(p_effective_date,trunc(sysdate))
1752: between per1.effective_start_date and per1.effective_end_date

Line 4983: ,p_person_id IN per_people_f.person_id%TYPE

4979: ,p_adj_basic_pay IN NUMBER
4980: ,p_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
4981: ,p_prd IN ghr_pa_requests.pay_rate_determinant%type
4982: ,p_pay_basis IN VARCHAR2
4983: ,p_person_id IN per_people_f.person_id%TYPE
4984: ,p_award_amount OUT NOCOPY NUMBER
4985: ,p_award_salary OUT NOCOPY NUMBER
4986: ) IS
4987: l_pay_table VARCHAR2(4);