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_MLC_PKG dependencies on GHR_PA_REQUESTS

Line 117: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;

113: l_step_or_rate varchar2(30);
114: l_pay_basis varchar2(30);
115: l_location_id number;
116: l_duty_station_id number;
117: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;
118: l_duty_station_code ghr_pa_requests.duty_station_code%type;
119: l_effective_date date;
120: l_personnel_office_id varchar2(300);
121: l_org_structure_id varchar2(300);

Line 118: l_duty_station_code ghr_pa_requests.duty_station_code%type;

114: l_pay_basis varchar2(30);
115: l_location_id number;
116: l_duty_station_id number;
117: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;
118: l_duty_station_code ghr_pa_requests.duty_station_code%type;
119: l_effective_date date;
120: l_personnel_office_id varchar2(300);
121: l_org_structure_id varchar2(300);
122: l_sub_element_code varchar2(300);

Line 178: l_sf52_rec ghr_pa_requests%rowtype;

174: l_p_PERSONNEL_OFFICE_ID varchar2(5);
175:
176: L_row_cnt number := 0;
177:
178: l_sf52_rec ghr_pa_requests%rowtype;
179: l_lac_sf52_rec ghr_pa_requests%rowtype;
180: l_errbuf varchar2(2000);
181:
182: l_retcode number;

Line 179: l_lac_sf52_rec ghr_pa_requests%rowtype;

175:
176: L_row_cnt number := 0;
177:
178: l_sf52_rec ghr_pa_requests%rowtype;
179: l_lac_sf52_rec ghr_pa_requests%rowtype;
180: l_errbuf varchar2(2000);
181:
182: l_retcode number;
183:

Line 317: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

313: ) then
314:
315: hr_utility.set_location('The location id is:'||l_location_id,12345);
316: begin
317: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
318: (p_location_id => l_location_id
319: ,p_duty_station_id => l_duty_station_id);
320: exception
321: when others then

Line 323: 'Error in Ghr_pa_requests_pkg.get_sf52_loc_ddf_details'||

319: ,p_duty_station_id => l_duty_station_id);
320: exception
321: when others then
322: hr_utility.set_location(
323: 'Error in Ghr_pa_requests_pkg.get_sf52_loc_ddf_details'||
324: 'Err is '||sqlerrm(sqlcode),20);
325: l_mlcerrbuf := 'Error in get_sf52_loc_ddf_details '||
326: 'Sql Err is '|| sqlerrm(sqlcode);
327: raise mlc_error;

Line 361: ghr_pa_requests_pkg.get_sf52_asg_ddf_details

357:
358: hr_utility.set_location('check_init_eligibility ' || l_proc,6);
359:
360: begin
361: ghr_pa_requests_pkg.get_sf52_asg_ddf_details
362: (l_assignment_id,
363: l_effective_date,
364: l_tenure,
365: l_annuitant_indicator,

Line 371: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details'||

367: l_work_schedule,
368: l_part_time_hour);
369: exception
370: when others then
371: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details'||
372: 'Err is '||sqlerrm(sqlcode),20);
373: l_mlcerrbuf := 'Error in get_sf52_asgddf_details Sql Err is '|| sqlerrm(sqlcode);
374: raise mlc_error;
375: end;

Line 415: ghr_pa_requests_pkg.get_duty_station_details

411: hr_utility.set_location('check_select_flg ' || l_proc,7);
412: BEGIN
413: hr_utility.set_location('The duty station name is:'||l_duty_station_code,12345);
414: hr_utility.set_location('The duty station desc is:'||l_duty_station_desc,12345);
415: ghr_pa_requests_pkg.get_duty_station_details
416: (p_duty_station_id => l_duty_station_id
417: ,p_effective_date => l_effective_date
418: ,p_duty_station_code => l_duty_station_code
419: ,p_duty_station_desc => l_duty_station_desc);

Line 422: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_duty_station_details'||

418: ,p_duty_station_code => l_duty_station_code
419: ,p_duty_station_desc => l_duty_station_desc);
420: EXCEPTION
421: when others then
422: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_duty_station_details'||
423: 'Err is '||sqlerrm(sqlcode),20);
424: l_mlcerrbuf := 'Error in get_duty_station_details Sql Err is '|| sqlerrm(sqlcode);
425: raise mlc_error;
426:

Line 622: l_capped_other_pay := ghr_pa_requests_pkg2.get_cop( p_assignment_id => l_assignment_id

618: hr_utility.set_location('Supervisory Diff Amount = ' || to_char(l_supervisory_differential),10);
619:
620: -------------Call Pay cap Procedure
621: begin
622: l_capped_other_pay := ghr_pa_requests_pkg2.get_cop( p_assignment_id => l_assignment_id
623: ,p_effective_date => l_effective_date);
624: l_old_capped_other_pay := l_capped_other_pay;
625: -- Sundar Added the following if statement to improve performance
626: if hr_utility.debug_enabled = true then

Line 907: l_pa_request_number ghr_pa_requests.request_number%TYPE;

903:
904: ------ Added by Dinkar for List reports problem
905:
906: DECLARE
907: l_pa_request_number ghr_pa_requests.request_number%TYPE;
908: BEGIN
909:
910: l_pa_request_number := l_sf52_rec.request_number||'-'||p_mass_salary_id;
911:

Line 1319: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;

1315: l_step_or_rate varchar2(30);
1316: l_pay_basis varchar2(30);
1317: l_location_id number;
1318: l_duty_station_id number;
1319: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;
1320: l_duty_station_code ghr_pa_requests.duty_station_code%type;
1321: l_effective_date date;
1322: l_personnel_office_id varchar2(300);
1323: l_org_structure_id varchar2(300);

Line 1320: l_duty_station_code ghr_pa_requests.duty_station_code%type;

1316: l_pay_basis varchar2(30);
1317: l_location_id number;
1318: l_duty_station_id number;
1319: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;
1320: l_duty_station_code ghr_pa_requests.duty_station_code%type;
1321: l_effective_date date;
1322: l_personnel_office_id varchar2(300);
1323: l_org_structure_id varchar2(300);
1324: l_sub_element_code varchar2(300);

Line 1379: l_sf52_rec ghr_pa_requests%rowtype;

1375: l_p_PERSONNEL_OFFICE_ID varchar2(5);
1376:
1377: L_row_cnt number := 0;
1378:
1379: l_sf52_rec ghr_pa_requests%rowtype;
1380: l_lac_sf52_rec ghr_pa_requests%rowtype;
1381: l_errbuf varchar2(2000);
1382:
1383: l_retcode number;

Line 1380: l_lac_sf52_rec ghr_pa_requests%rowtype;

1376:
1377: L_row_cnt number := 0;
1378:
1379: l_sf52_rec ghr_pa_requests%rowtype;
1380: l_lac_sf52_rec ghr_pa_requests%rowtype;
1381: l_errbuf varchar2(2000);
1382:
1383: l_retcode number;
1384:

Line 1531: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

1527: l_location_id := p_location_id;
1528:
1529: hr_utility.set_location('The location id is:'||l_location_id,12345);
1530: begin
1531: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
1532: (p_location_id => l_location_id
1533: ,p_duty_station_id => l_duty_station_id);
1534: exception
1535: when others then

Line 1537: 'Error in Ghr_pa_requests_pkg.get_sf52_loc_ddf_details'||

1533: ,p_duty_station_id => l_duty_station_id);
1534: exception
1535: when others then
1536: hr_utility.set_location(
1537: 'Error in Ghr_pa_requests_pkg.get_sf52_loc_ddf_details'||
1538: 'Err is '||sqlerrm(sqlcode),20);
1539: l_mtcerrbuf := 'Error in get_sf52_loc_ddf_details '||
1540: 'Sql Err is '|| sqlerrm(sqlcode);
1541: raise mtc_error;

Line 1591: ghr_pa_requests_pkg.get_sf52_asg_ddf_details

1587: hr_utility.set_location('check_init_eligibility ' || l_proc,6);
1588: -- Get PRD, work schedule etc form ASG EI
1589:
1590: begin
1591: ghr_pa_requests_pkg.get_sf52_asg_ddf_details
1592: (l_assignment_id,
1593: l_effective_date,
1594: l_tenure,
1595: l_annuitant_indicator,

Line 1601: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details'||

1597: l_work_schedule,
1598: l_part_time_hour);
1599: exception
1600: when others then
1601: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details'||
1602: 'Err is '||sqlerrm(sqlcode),20);
1603: l_mtcerrbuf := 'Error in get_sf52_asgddf_details Sql Err is '|| sqlerrm(sqlcode);
1604: raise mtc_error;
1605: end;

Line 1655: ghr_pa_requests_pkg.get_duty_station_details

1651: hr_utility.set_location('The duty station name is:'||l_duty_station_code,12345);
1652: hr_utility.set_location('The duty station desc is:'||l_duty_station_desc,12345);
1653:
1654: begin
1655: ghr_pa_requests_pkg.get_duty_station_details
1656: (p_duty_station_id => l_duty_station_id
1657: ,p_effective_date => l_effective_date
1658: ,p_duty_station_code => l_duty_station_code
1659: ,p_duty_station_desc => l_duty_station_desc);

Line 1662: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_duty_station_details'||

1658: ,p_duty_station_code => l_duty_station_code
1659: ,p_duty_station_desc => l_duty_station_desc);
1660: exception
1661: when others then
1662: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_duty_station_details'||
1663: 'Err is '||sqlerrm(sqlcode),20);
1664: l_mtcerrbuf := 'Error in get_duty_station_details Sql Err is '|| sqlerrm(sqlcode);
1665: raise mtc_error;
1666: end;

Line 1849: l_capped_other_pay := ghr_pa_requests_pkg2.get_cop( p_assignment_id => l_assignment_id

1845:
1846:
1847: -------------Call Pay cap Procedure
1848: begin
1849: l_capped_other_pay := ghr_pa_requests_pkg2.get_cop( p_assignment_id => l_assignment_id
1850: ,p_effective_date => l_effective_date);
1851: l_old_capped_other_pay := l_capped_other_pay;
1852: -- Sundar Added the following if statement to improve performance
1853: if hr_utility.debug_enabled = true then

Line 2108: l_pa_request_number ghr_pa_requests.request_number%TYPE;

2104:
2105: ------ Added by Dinkar for List reports problem
2106:
2107: declare
2108: l_pa_request_number ghr_pa_requests.request_number%TYPE;
2109: begin
2110:
2111: l_pa_request_number :=
2112: l_sf52_rec.request_number||'-'||p_mass_salary_id;

Line 2420: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

2416: l_location_id := un_per.location_id;
2417:
2418: hr_utility.set_location('position valid grade table id is ' || to_char(l_pay_table_id) || l_proc,45);
2419: BEGIN
2420: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
2421: (p_location_id => l_location_id
2422: ,p_duty_station_id => l_duty_station_id);
2423: END;
2424:

Line 2507: ghr_pa_requests_pkg.get_duty_station_details

2503:
2504: hr_utility.set_location('check l_pay_plan ' || l_pay_plan || l_proc,58);
2505: hr_utility.set_location('check l_grade_or_level ' || l_grade_or_level || l_proc,58);
2506: BEGIN
2507: ghr_pa_requests_pkg.get_duty_station_details
2508: (p_duty_station_id => l_duty_station_id
2509: ,p_effective_DATE => l_effective_DATE
2510: ,p_duty_station_code => l_duty_station_code
2511: ,p_duty_station_desc => l_duty_station_desc);

Line 2840: from ghr_pa_requests

2836: input_pay_rate_determinant,
2837: from_pay_table_identifier,
2838: to_pay_table_identifier
2839: -- FWFA Changes
2840: from ghr_pa_requests
2841: where person_id = p_person_id
2842: and effective_date = p_effective_date
2843: and substr(request_number,(instr(request_number,'-')+1)) = to_char(p_mass_salary_id)
2844: and first_noa_code = nvl(ghr_msl_pkg.g_first_noa_code,'895');

Line 2989: from ghr_pa_requests

2985: input_pay_rate_determinant,
2986: from_pay_table_identifier,
2987: to_pay_table_identifier
2988: -- FWFA Changes
2989: from ghr_pa_requests
2990: where person_id = p_person_id
2991: and effective_date = p_effective_date
2992: and substr(request_number,(instr(request_number,'-')+1)) = to_char(p_mass_salary_id)
2993: and first_noa_code in ('894','800');

Line 3567: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;

3563: )
3564: return boolean is
3565: --
3566: l_name per_people_f.full_name%type;
3567: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
3568:
3569: cursor csr_action_taken is
3570: select pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id
3571: from ghr_pa_requests pr, ghr_pa_routing_history prh

Line 3571: from ghr_pa_requests pr, ghr_pa_routing_history prh

3567: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
3568:
3569: cursor csr_action_taken is
3570: select pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id
3571: from ghr_pa_requests pr, ghr_pa_routing_history prh
3572: where pr.pa_request_id = prh.pa_request_id
3573: and person_id = p_person_id
3574: and first_noa_code = p_first_noa_code
3575: and effective_date = p_effective_date

Line 3583: from ghr_pa_requests pr

3579: group by pr.pa_request_id;
3580:
3581: cursor csr_name is
3582: select substr(pr.employee_last_name || ', ' || pr.employee_first_name,1,240) fname
3583: from ghr_pa_requests pr
3584: where pr.pa_request_id = l_pa_request_id;
3585:
3586: cursor csr_action_taken_fw is
3587: select pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id

Line 3588: from ghr_pa_requests pr, ghr_pa_routing_history prh

3584: where pr.pa_request_id = l_pa_request_id;
3585:
3586: cursor csr_action_taken_fw is
3587: select pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id
3588: from ghr_pa_requests pr, ghr_pa_routing_history prh
3589: where pr.pa_request_id = prh.pa_request_id
3590: and person_id = p_person_id
3591: and first_noa_code = p_first_noa_code
3592: and effective_date = p_effective_date

Line 3743: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;

3739: )
3740: return boolean is
3741: --
3742: l_name per_people_f.full_name%type;
3743: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
3744:
3745: cursor csr_action_taken is
3746: select pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id
3747: from ghr_pa_requests pr, ghr_pa_routing_history prh

Line 3747: from ghr_pa_requests pr, ghr_pa_routing_history prh

3743: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
3744:
3745: cursor csr_action_taken is
3746: select pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id
3747: from ghr_pa_requests pr, ghr_pa_routing_history prh
3748: where pr.pa_request_id = prh.pa_request_id
3749: and person_id = p_person_id
3750: and (first_noa_code = p_first_noa_code or first_noa_code = '800')
3751: and effective_date = p_effective_date

Line 3757: from ghr_pa_requests pr

3753: group by pr.pa_request_id;
3754:
3755: cursor csr_name is
3756: select substr(pr.employee_last_name || ', ' || pr.employee_first_name,1,240) fname
3757: from ghr_pa_requests pr
3758: where pr.pa_request_id = l_pa_request_id;
3759:
3760: cursor csr_action_taken_fw is
3761: select pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id

Line 3762: from ghr_pa_requests pr, ghr_pa_routing_history prh

3758: where pr.pa_request_id = l_pa_request_id;
3759:
3760: cursor csr_action_taken_fw is
3761: select pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id
3762: from ghr_pa_requests pr, ghr_pa_routing_history prh
3763: where pr.pa_request_id = prh.pa_request_id
3764: and person_id = p_person_id
3765: and (first_noa_code = p_first_noa_code or first_noa_code = '800')
3766: and effective_date = p_effective_date

Line 4939: p_sf52_rec out nocopy ghr_pa_requests%rowtype) IS

4935: --
4936:
4937: procedure get_lac_dtls
4938: (p_pa_request_id in number,
4939: p_sf52_rec out nocopy ghr_pa_requests%rowtype) IS
4940:
4941: l_proc varchar2(72) := g_package || '.get_lac_dtls';
4942:
4943: cursor cur_pa_req_cur is

Line 4944: select * from ghr_pa_requests

4940:
4941: l_proc varchar2(72) := g_package || '.get_lac_dtls';
4942:
4943: cursor cur_pa_req_cur is
4944: select * from ghr_pa_requests
4945: where pa_request_id = p_pa_request_id;
4946:
4947: begin
4948: g_proc := 'get_lac_dtls';

Line 5122: p_duty_station_code in ghr_pa_requests.duty_station_code%type,

5118: p_to_supervisory_differential in number,
5119: p_to_supervisory_diff_perce in number,
5120: p_to_staffing_differential in number,
5121: p_duty_station_id in number,
5122: p_duty_station_code in ghr_pa_requests.duty_station_code%type,
5123: p_duty_station_desc in ghr_pa_requests.duty_station_desc%type,
5124: -- FWFA Changes Bug#4444609
5125: p_input_pay_rate_determinant in ghr_pa_requests.input_pay_rate_determinant%type,
5126: p_from_pay_table_id in ghr_pa_requests.from_pay_table_identifier%type,

Line 5123: p_duty_station_desc in ghr_pa_requests.duty_station_desc%type,

5119: p_to_supervisory_diff_perce in number,
5120: p_to_staffing_differential in number,
5121: p_duty_station_id in number,
5122: p_duty_station_code in ghr_pa_requests.duty_station_code%type,
5123: p_duty_station_desc in ghr_pa_requests.duty_station_desc%type,
5124: -- FWFA Changes Bug#4444609
5125: p_input_pay_rate_determinant in ghr_pa_requests.input_pay_rate_determinant%type,
5126: p_from_pay_table_id in ghr_pa_requests.from_pay_table_identifier%type,
5127: p_to_pay_table_id in ghr_pa_requests.to_pay_table_identifier%type,

Line 5125: p_input_pay_rate_determinant in ghr_pa_requests.input_pay_rate_determinant%type,

5121: p_duty_station_id in number,
5122: p_duty_station_code in ghr_pa_requests.duty_station_code%type,
5123: p_duty_station_desc in ghr_pa_requests.duty_station_desc%type,
5124: -- FWFA Changes Bug#4444609
5125: p_input_pay_rate_determinant in ghr_pa_requests.input_pay_rate_determinant%type,
5126: p_from_pay_table_id in ghr_pa_requests.from_pay_table_identifier%type,
5127: p_to_pay_table_id in ghr_pa_requests.to_pay_table_identifier%type,
5128: -- FWFA Changes
5129: p_lac_sf52_rec in ghr_pa_requests%rowtype,

Line 5126: p_from_pay_table_id in ghr_pa_requests.from_pay_table_identifier%type,

5122: p_duty_station_code in ghr_pa_requests.duty_station_code%type,
5123: p_duty_station_desc in ghr_pa_requests.duty_station_desc%type,
5124: -- FWFA Changes Bug#4444609
5125: p_input_pay_rate_determinant in ghr_pa_requests.input_pay_rate_determinant%type,
5126: p_from_pay_table_id in ghr_pa_requests.from_pay_table_identifier%type,
5127: p_to_pay_table_id in ghr_pa_requests.to_pay_table_identifier%type,
5128: -- FWFA Changes
5129: p_lac_sf52_rec in ghr_pa_requests%rowtype,
5130: p_sf52_rec out nocopy ghr_pa_requests%rowtype) IS

Line 5127: p_to_pay_table_id in ghr_pa_requests.to_pay_table_identifier%type,

5123: p_duty_station_desc in ghr_pa_requests.duty_station_desc%type,
5124: -- FWFA Changes Bug#4444609
5125: p_input_pay_rate_determinant in ghr_pa_requests.input_pay_rate_determinant%type,
5126: p_from_pay_table_id in ghr_pa_requests.from_pay_table_identifier%type,
5127: p_to_pay_table_id in ghr_pa_requests.to_pay_table_identifier%type,
5128: -- FWFA Changes
5129: p_lac_sf52_rec in ghr_pa_requests%rowtype,
5130: p_sf52_rec out nocopy ghr_pa_requests%rowtype) IS
5131:

Line 5129: p_lac_sf52_rec in ghr_pa_requests%rowtype,

5125: p_input_pay_rate_determinant in ghr_pa_requests.input_pay_rate_determinant%type,
5126: p_from_pay_table_id in ghr_pa_requests.from_pay_table_identifier%type,
5127: p_to_pay_table_id in ghr_pa_requests.to_pay_table_identifier%type,
5128: -- FWFA Changes
5129: p_lac_sf52_rec in ghr_pa_requests%rowtype,
5130: p_sf52_rec out nocopy ghr_pa_requests%rowtype) IS
5131:
5132: l_proc varchar2(72) := g_package || '.assign_to_sf52_rec';
5133: begin

Line 5130: p_sf52_rec out nocopy ghr_pa_requests%rowtype) IS

5126: p_from_pay_table_id in ghr_pa_requests.from_pay_table_identifier%type,
5127: p_to_pay_table_id in ghr_pa_requests.to_pay_table_identifier%type,
5128: -- FWFA Changes
5129: p_lac_sf52_rec in ghr_pa_requests%rowtype,
5130: p_sf52_rec out nocopy ghr_pa_requests%rowtype) IS
5131:
5132: l_proc varchar2(72) := g_package || '.assign_to_sf52_rec';
5133: begin
5134:

Line 5466: l_his_eff_date ghr_pa_requests.effective_date%type;

5462: AND HR_GENERAL.DECODE_AVAILABILITY_STATUS(pos.availability_status_id) = 'Active');
5463:
5464: l_hist_id ghr_pa_history.pa_history_id%type;
5465: l_position_id per_assignments_f.position_id%type;
5466: l_his_eff_date ghr_pa_requests.effective_date%type;
5467: l_user_tab_id pay_user_tables.user_table_id%type;
5468:
5469:
5470: begin

Line 5511: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;

5507: )
5508: return boolean is
5509: --
5510: l_name per_people_f.full_name%type;
5511: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
5512:
5513: cursor csr_action_taken is
5514: select pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id
5515: from ghr_pa_requests pr, ghr_pa_routing_history prh

Line 5515: from ghr_pa_requests pr, ghr_pa_routing_history prh

5511: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
5512:
5513: cursor csr_action_taken is
5514: select pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id
5515: from ghr_pa_requests pr, ghr_pa_routing_history prh
5516: where pr.pa_request_id = prh.pa_request_id
5517: and person_id = p_person_id
5518: and first_noa_code = p_first_noa_code
5519: and effective_date = p_effective_date

Line 5525: from ghr_pa_requests pr

5521: group by pr.pa_request_id;
5522:
5523: cursor csr_name is
5524: select substr(pr.employee_last_name || ', ' || pr.employee_first_name,1,240) fname
5525: from ghr_pa_requests pr
5526: where pr.pa_request_id = l_pa_request_id;
5527:
5528:
5529: cursor pa_hist_cur (p_r_hist_id number) is