APPS.GHR_PA_REQUESTS_PKG dependencies on PER_POSITION_EXTRA_INFO

Line 293: l_pos_psi_data per_position_extra_info%rowtype;

289: FUNCTION get_personnel_system_indicator(
290: p_position_id hr_all_positions_f.position_id%TYPE
291: ,p_effective_date date)
292: RETURN VARCHAR2 IS
293: l_pos_psi_data per_position_extra_info%rowtype;
294: l_personnel_system_indicator VARCHAR2(30);
295: BEGIN
296: hr_utility.set_location('Entering get_psi',0);
297: ghr_history_fetch.fetch_positionei(

Line 827: l_pos_ei_grp1_data per_position_extra_info%rowtype;

823: ,p_personnel_office_id OUT NOCOPY varchar2
824: ,p_office_symbol OUT NOCOPY varchar2
825: ,p_part_time_hours OUT NOCOPY number) IS
826:
827: l_pos_ei_grp1_data per_position_extra_info%rowtype;
828: l_pos_ei_grp2_data per_position_extra_info%rowtype;
829: --l_dummy_posei per_position_extra_info%rowtype;
830:
831: BEGIN

Line 828: l_pos_ei_grp2_data per_position_extra_info%rowtype;

824: ,p_office_symbol OUT NOCOPY varchar2
825: ,p_part_time_hours OUT NOCOPY number) IS
826:
827: l_pos_ei_grp1_data per_position_extra_info%rowtype;
828: l_pos_ei_grp2_data per_position_extra_info%rowtype;
829: --l_dummy_posei per_position_extra_info%rowtype;
830:
831: BEGIN
832:

Line 829: --l_dummy_posei per_position_extra_info%rowtype;

825: ,p_part_time_hours OUT NOCOPY number) IS
826:
827: l_pos_ei_grp1_data per_position_extra_info%rowtype;
828: l_pos_ei_grp2_data per_position_extra_info%rowtype;
829: --l_dummy_posei per_position_extra_info%rowtype;
830:
831: BEGIN
832:
833: ghr_history_fetch.fetch_positionei(

Line 980: l_pos_ei_grade_data per_position_extra_info%rowtype;

976: ,p_duty_station_id OUT NOCOPY number
977: ) IS
978: --
979: l_business_group_id hr_all_positions_f.business_group_id%type;
980: l_pos_ei_grade_data per_position_extra_info%rowtype;
981: l_pos_ei_grp1_data per_position_extra_info%rowtype;
982:
983: l_pos_organization_id hr_organization_information.organization_id%TYPE;
984: l_assignment_id per_all_assignments_f.assignment_id%type;

Line 981: l_pos_ei_grp1_data per_position_extra_info%rowtype;

977: ) IS
978: --
979: l_business_group_id hr_all_positions_f.business_group_id%type;
980: l_pos_ei_grade_data per_position_extra_info%rowtype;
981: l_pos_ei_grp1_data per_position_extra_info%rowtype;
982:
983: l_pos_organization_id hr_organization_information.organization_id%TYPE;
984: l_assignment_id per_all_assignments_f.assignment_id%type;
985: l_retained_grade ghr_pay_calc.retained_grade_rec_type;

Line 1928: l_pos_ei_data per_position_extra_info%rowtype;

1924: ) RETURN varchar2 IS
1925:
1926:
1927: l_proc varchar2(72) := 'get_position_work_title';
1928: l_pos_ei_data per_position_extra_info%rowtype;
1929: l_title varchar2(150);
1930:
1931:
1932: BEGIN

Line 1957: l_pos_ei_data per_position_extra_info%rowtype;

1953:
1954:
1955: l_proc varchar2(72) := 'get_position_work_title';
1956: l_position_id hr_all_positions_f.position_id%type;
1957: l_pos_ei_data per_position_extra_info%rowtype;
1958: l_title varchar2(150);
1959:
1960: CURSOR c_per_pos is
1961: SELECT asg.position_id

Line 2031: l_pos_ei_grade_data per_position_extra_info%rowtype;

2027: ,p_effective_date IN DATE)
2028: RETURN VARCHAR2 IS
2029: l_retained_grade ghr_pay_calc.retained_grade_rec_type;
2030: l_update34_date DATE;
2031: l_pos_ei_grade_data per_position_extra_info%rowtype;
2032: BEGIN
2033: hr_utility.set_location('Entering get_upd34_pay_basis',10);
2034: begin
2035: l_retained_grade := ghr_pc_basic_pay.get_retained_grade_details (p_person_id