eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_MASS_SEL_NOA dependencies on PER_POSITION_EXTRA_INFO

Line 631: l_pos_grp1_rec per_position_extra_info%ROWTYPE;

627: AND pay_plan = cur_pay_plan
628: AND pay_rate_determinant = cur_prd;
629:
630: l_row_cnt number DEFAULT 0;
631: l_pos_grp1_rec per_position_extra_info%ROWTYPE;
632: l_assignment_id per_assignments_f.assignment_id%TYPE;
633: l_person_id per_assignments_f.person_id%TYPE;
634: l_position_id per_assignments_f.position_id%TYPE;
635: l_grade_id per_assignments_f.grade_id%TYPE;

Line 1455: , p_pos_ei_data OUT NOCOPY per_position_extra_info%ROWTYPE) IS

1451: , p_effective_date IN date
1452: , p_flsa_category OUT NOCOPY varchar2
1453: , p_barg_unit_status OUT NOCOPY varchar2
1454: , p_functional_class OUT NOCOPY varchar2 -- Bug# 14410401
1455: , p_pos_ei_data OUT NOCOPY per_position_extra_info%ROWTYPE) IS
1456: l_proc varchar2(72) DEFAULT g_package|| '.get_pos_grp1_ddf';
1457: BEGIN
1458: g_proc := 'get_pos_grp1_ddf';
1459:

Line 1581: l_pos_ei_data per_position_extra_info%ROWTYPE;

1577: l_sf52_rec ghr_pa_requests%ROWTYPE;
1578: l_lac_sf52_rec ghr_pa_requests%ROWTYPE;
1579: l_errbuf varchar2(2000);
1580: l_retcode number;
1581: l_pos_ei_data per_position_extra_info%ROWTYPE;
1582: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
1583: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;
1584: l_sel_flg varchar2(2);
1585: l_first_action_la_code1 varchar2(30);

Line 1611: l_new_pos_grp1_rec per_position_extra_info%rowtype;

1607: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
1608: ---Vacant position variables
1609: l_avail_status_id NUMBER;
1610: l_position_data_rec ghr_sf52_pos_UPDATE.position_data_rec_type;
1611: l_new_pos_grp1_rec per_position_extra_info%rowtype;
1612: l_pos_valid_grade_ei_data per_position_extra_info%rowtype;
1613:
1614: CURSOR cur_active_people
1615: (effective_date IN date) IS

Line 1612: l_pos_valid_grade_ei_data per_position_extra_info%rowtype;

1608: ---Vacant position variables
1609: l_avail_status_id NUMBER;
1610: l_position_data_rec ghr_sf52_pos_UPDATE.position_data_rec_type;
1611: l_new_pos_grp1_rec per_position_extra_info%rowtype;
1612: l_pos_valid_grade_ei_data per_position_extra_info%rowtype;
1613:
1614: CURSOR cur_active_people
1615: (effective_date IN date) IS
1616: SELECT ppf.person_id person_id

Line 2037: l_vac_flsa_category per_position_extra_info.poei_information7%TYPE;

2033: , p_step_or_rate IN varchar2
2034: , p_pay_basis IN varchar2) IS
2035: l_proc varchar2(72) DEFAULT g_package
2036: || 'vacant_pos_process';
2037: l_vac_flsa_category per_position_extra_info.poei_information7%TYPE;
2038: l_vac_barg_unit_status per_position_extra_info.poei_information8%TYPE;
2039: l_vac_duty_location_id ghr_pa_requests.duty_station_location_id%TYPE;
2040: l_vac_functional_class per_position_extra_info.poei_information11%TYPE;
2041: -- Begin Bug# 14751973

Line 2038: l_vac_barg_unit_status per_position_extra_info.poei_information8%TYPE;

2034: , p_pay_basis IN varchar2) IS
2035: l_proc varchar2(72) DEFAULT g_package
2036: || 'vacant_pos_process';
2037: l_vac_flsa_category per_position_extra_info.poei_information7%TYPE;
2038: l_vac_barg_unit_status per_position_extra_info.poei_information8%TYPE;
2039: l_vac_duty_location_id ghr_pa_requests.duty_station_location_id%TYPE;
2040: l_vac_functional_class per_position_extra_info.poei_information11%TYPE;
2041: -- Begin Bug# 14751973
2042: l_vac_duty_station_code ghr_mass_salaries.target_duty_station_code%type;

Line 2040: l_vac_functional_class per_position_extra_info.poei_information11%TYPE;

2036: || 'vacant_pos_process';
2037: l_vac_flsa_category per_position_extra_info.poei_information7%TYPE;
2038: l_vac_barg_unit_status per_position_extra_info.poei_information8%TYPE;
2039: l_vac_duty_location_id ghr_pa_requests.duty_station_location_id%TYPE;
2040: l_vac_functional_class per_position_extra_info.poei_information11%TYPE;
2041: -- Begin Bug# 14751973
2042: l_vac_duty_station_code ghr_mass_salaries.target_duty_station_code%type;
2043: l_vac_duty_station_desc varchar2(150);
2044: l_vac_occ_code ghr_mass_salaries.target_occ_code%type;