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

Line 9: p_pa_request_rec in ghr_pa_requests%rowtype

5:
6:
7: procedure GHRWS52L
8: (
9: p_pa_request_rec in ghr_pa_requests%rowtype
10: ,p_per_group1 in ghr_api.per_group1_type
11: ,p_per_retained_grade in ghr_api.per_retained_grade_type
12: ,p_per_sep_retire in ghr_api.per_sep_retire_type
13: ,p_per_conversions in ghr_api.per_conversions_type

Line 29: l_academic_discipline ghr_pa_requests.ACADEMIC_DISCIPLINE%Type;

25: )
26: is
27: --
28: l_proc varchar2(61) := 'GHR_GHRWS52L.GHRWS52';
29: l_academic_discipline ghr_pa_requests.ACADEMIC_DISCIPLINE%Type;
30: l_Adj_Base_Pay ghr_pa_requests.TO_ADJ_BASIC_PAY%type;
31: l_Agency_Code varchar2(30);
32: -- l_Agency varchar2(30);
33: l_agency_subelement varchar2(30);

Line 30: l_Adj_Base_Pay ghr_pa_requests.TO_ADJ_BASIC_PAY%type;

26: is
27: --
28: l_proc varchar2(61) := 'GHR_GHRWS52L.GHRWS52';
29: l_academic_discipline ghr_pa_requests.ACADEMIC_DISCIPLINE%Type;
30: l_Adj_Base_Pay ghr_pa_requests.TO_ADJ_BASIC_PAY%type;
31: l_Agency_Code varchar2(30);
32: -- l_Agency varchar2(30);
33: l_agency_subelement varchar2(30);
34: l_as_of_date date;

Line 36: l_bargaining_unit_status_code ghr_pa_requests.BARGAINING_UNIT_STATUS%type;

32: -- l_Agency varchar2(30);
33: l_agency_subelement varchar2(30);
34: l_as_of_date date;
35: l_Benefit_Amount ghr_pa_request_extra_info.rei_information7%type;
36: l_bargaining_unit_status_code ghr_pa_requests.BARGAINING_UNIT_STATUS%type;
37: l_citizenship ghr_pa_requests.CITIZENSHIP%type;
38: l_credit_mil_svc per_people_extra_info.pei_information5%type;
39: l_Cur_Appt_Auth_1 per_people_extra_info.pei_information8%type;
40: l_Cur_Appt_Auth_2 per_people_extra_info.pei_information9%type;

Line 37: l_citizenship ghr_pa_requests.CITIZENSHIP%type;

33: l_agency_subelement varchar2(30);
34: l_as_of_date date;
35: l_Benefit_Amount ghr_pa_request_extra_info.rei_information7%type;
36: l_bargaining_unit_status_code ghr_pa_requests.BARGAINING_UNIT_STATUS%type;
37: l_citizenship ghr_pa_requests.CITIZENSHIP%type;
38: l_credit_mil_svc per_people_extra_info.pei_information5%type;
39: l_Cur_Appt_Auth_1 per_people_extra_info.pei_information8%type;
40: l_Cur_Appt_Auth_2 per_people_extra_info.pei_information9%type;
41: l_Duty_Station_ID hr_location_extra_info.lei_information3%type;

Line 43: l_education_level ghr_pa_requests.EDUCATION_LEVEL%type;

39: l_Cur_Appt_Auth_1 per_people_extra_info.pei_information8%type;
40: l_Cur_Appt_Auth_2 per_people_extra_info.pei_information9%type;
41: l_Duty_Station_ID hr_location_extra_info.lei_information3%type;
42: l_Duty_Station_Lookup_Code ghr_duty_stations_f.Duty_Station_Code%type;
43: l_education_level ghr_pa_requests.EDUCATION_LEVEL%type;
44: l_effective_date ghr_pa_requests.EFFECTIVE_DATE%type;
45: l_Employee_Date_of_Birth per_people_f.date_of_birth%type;
46: l_Employee_First_Name ghr_pa_requests.EMPLOYEE_FIRST_NAME%type;
47: l_Employee_Last_Name ghr_pa_requests.EMPLOYEE_LAST_NAME%type;

Line 44: l_effective_date ghr_pa_requests.EFFECTIVE_DATE%type;

40: l_Cur_Appt_Auth_2 per_people_extra_info.pei_information9%type;
41: l_Duty_Station_ID hr_location_extra_info.lei_information3%type;
42: l_Duty_Station_Lookup_Code ghr_duty_stations_f.Duty_Station_Code%type;
43: l_education_level ghr_pa_requests.EDUCATION_LEVEL%type;
44: l_effective_date ghr_pa_requests.EFFECTIVE_DATE%type;
45: l_Employee_Date_of_Birth per_people_f.date_of_birth%type;
46: l_Employee_First_Name ghr_pa_requests.EMPLOYEE_FIRST_NAME%type;
47: l_Employee_Last_Name ghr_pa_requests.EMPLOYEE_LAST_NAME%type;
48: l_employee_National_ID per_people_f.national_identifier%type;

Line 46: l_Employee_First_Name ghr_pa_requests.EMPLOYEE_FIRST_NAME%type;

42: l_Duty_Station_Lookup_Code ghr_duty_stations_f.Duty_Station_Code%type;
43: l_education_level ghr_pa_requests.EDUCATION_LEVEL%type;
44: l_effective_date ghr_pa_requests.EFFECTIVE_DATE%type;
45: l_Employee_Date_of_Birth per_people_f.date_of_birth%type;
46: l_Employee_First_Name ghr_pa_requests.EMPLOYEE_FIRST_NAME%type;
47: l_Employee_Last_Name ghr_pa_requests.EMPLOYEE_LAST_NAME%type;
48: l_employee_National_ID per_people_f.national_identifier%type;
49: l_fegli_code ghr_pa_requests.FEGLI%type;
50: l_fers_coverage per_people_extra_info.pei_information3%type;

Line 47: l_Employee_Last_Name ghr_pa_requests.EMPLOYEE_LAST_NAME%type;

43: l_education_level ghr_pa_requests.EDUCATION_LEVEL%type;
44: l_effective_date ghr_pa_requests.EFFECTIVE_DATE%type;
45: l_Employee_Date_of_Birth per_people_f.date_of_birth%type;
46: l_Employee_First_Name ghr_pa_requests.EMPLOYEE_FIRST_NAME%type;
47: l_Employee_Last_Name ghr_pa_requests.EMPLOYEE_LAST_NAME%type;
48: l_employee_National_ID per_people_f.national_identifier%type;
49: l_fegli_code ghr_pa_requests.FEGLI%type;
50: l_fers_coverage per_people_extra_info.pei_information3%type;
51: l_First_Action_NOA_LA_Code1 ghr_pa_requests.FIRST_ACTION_LA_CODE1%type;

Line 49: l_fegli_code ghr_pa_requests.FEGLI%type;

45: l_Employee_Date_of_Birth per_people_f.date_of_birth%type;
46: l_Employee_First_Name ghr_pa_requests.EMPLOYEE_FIRST_NAME%type;
47: l_Employee_Last_Name ghr_pa_requests.EMPLOYEE_LAST_NAME%type;
48: l_employee_National_ID per_people_f.national_identifier%type;
49: l_fegli_code ghr_pa_requests.FEGLI%type;
50: l_fers_coverage per_people_extra_info.pei_information3%type;
51: l_First_Action_NOA_LA_Code1 ghr_pa_requests.FIRST_ACTION_LA_CODE1%type;
52: l_First_Action_NOA_LA_Code2 ghr_pa_requests.FIRST_ACTION_LA_CODE2%type;
53: l_First_NOAC_Lookup_Code ghr_pa_requests.FIRST_NOA_CODE%type;

Line 51: l_First_Action_NOA_LA_Code1 ghr_pa_requests.FIRST_ACTION_LA_CODE1%type;

47: l_Employee_Last_Name ghr_pa_requests.EMPLOYEE_LAST_NAME%type;
48: l_employee_National_ID per_people_f.national_identifier%type;
49: l_fegli_code ghr_pa_requests.FEGLI%type;
50: l_fers_coverage per_people_extra_info.pei_information3%type;
51: l_First_Action_NOA_LA_Code1 ghr_pa_requests.FIRST_ACTION_LA_CODE1%type;
52: l_First_Action_NOA_LA_Code2 ghr_pa_requests.FIRST_ACTION_LA_CODE2%type;
53: l_First_NOAC_Lookup_Code ghr_pa_requests.FIRST_NOA_CODE%type;
54: -- Bug#4486823 RRR Changes
55: l_First_NOAC_Lookup_Desc ghr_pa_requests.FIRST_NOA_DESC%type;

Line 52: l_First_Action_NOA_LA_Code2 ghr_pa_requests.FIRST_ACTION_LA_CODE2%type;

48: l_employee_National_ID per_people_f.national_identifier%type;
49: l_fegli_code ghr_pa_requests.FEGLI%type;
50: l_fers_coverage per_people_extra_info.pei_information3%type;
51: l_First_Action_NOA_LA_Code1 ghr_pa_requests.FIRST_ACTION_LA_CODE1%type;
52: l_First_Action_NOA_LA_Code2 ghr_pa_requests.FIRST_ACTION_LA_CODE2%type;
53: l_First_NOAC_Lookup_Code ghr_pa_requests.FIRST_NOA_CODE%type;
54: -- Bug#4486823 RRR Changes
55: l_First_NOAC_Lookup_Desc ghr_pa_requests.FIRST_NOA_DESC%type;
56: l_flsa_category ghr_pa_requests.FLSA_CATEGORY%type;

Line 53: l_First_NOAC_Lookup_Code ghr_pa_requests.FIRST_NOA_CODE%type;

49: l_fegli_code ghr_pa_requests.FEGLI%type;
50: l_fers_coverage per_people_extra_info.pei_information3%type;
51: l_First_Action_NOA_LA_Code1 ghr_pa_requests.FIRST_ACTION_LA_CODE1%type;
52: l_First_Action_NOA_LA_Code2 ghr_pa_requests.FIRST_ACTION_LA_CODE2%type;
53: l_First_NOAC_Lookup_Code ghr_pa_requests.FIRST_NOA_CODE%type;
54: -- Bug#4486823 RRR Changes
55: l_First_NOAC_Lookup_Desc ghr_pa_requests.FIRST_NOA_DESC%type;
56: l_flsa_category ghr_pa_requests.FLSA_CATEGORY%type;
57: l_functional_class ghr_pa_requests.FUNCTIONAL_CLASS%type;

Line 55: l_First_NOAC_Lookup_Desc ghr_pa_requests.FIRST_NOA_DESC%type;

51: l_First_Action_NOA_LA_Code1 ghr_pa_requests.FIRST_ACTION_LA_CODE1%type;
52: l_First_Action_NOA_LA_Code2 ghr_pa_requests.FIRST_ACTION_LA_CODE2%type;
53: l_First_NOAC_Lookup_Code ghr_pa_requests.FIRST_NOA_CODE%type;
54: -- Bug#4486823 RRR Changes
55: l_First_NOAC_Lookup_Desc ghr_pa_requests.FIRST_NOA_DESC%type;
56: l_flsa_category ghr_pa_requests.FLSA_CATEGORY%type;
57: l_functional_class ghr_pa_requests.FUNCTIONAL_CLASS%type;
58: l_health_plan varchar2(30);
59: l_Handicap per_people_extra_info.pei_information11%type;

Line 56: l_flsa_category ghr_pa_requests.FLSA_CATEGORY%type;

52: l_First_Action_NOA_LA_Code2 ghr_pa_requests.FIRST_ACTION_LA_CODE2%type;
53: l_First_NOAC_Lookup_Code ghr_pa_requests.FIRST_NOA_CODE%type;
54: -- Bug#4486823 RRR Changes
55: l_First_NOAC_Lookup_Desc ghr_pa_requests.FIRST_NOA_DESC%type;
56: l_flsa_category ghr_pa_requests.FLSA_CATEGORY%type;
57: l_functional_class ghr_pa_requests.FUNCTIONAL_CLASS%type;
58: l_health_plan varchar2(30);
59: l_Handicap per_people_extra_info.pei_information11%type;
60: l_Indiv_Award ghr_pa_request_extra_info.rei_information6%type;

Line 57: l_functional_class ghr_pa_requests.FUNCTIONAL_CLASS%type;

53: l_First_NOAC_Lookup_Code ghr_pa_requests.FIRST_NOA_CODE%type;
54: -- Bug#4486823 RRR Changes
55: l_First_NOAC_Lookup_Desc ghr_pa_requests.FIRST_NOA_DESC%type;
56: l_flsa_category ghr_pa_requests.FLSA_CATEGORY%type;
57: l_functional_class ghr_pa_requests.FUNCTIONAL_CLASS%type;
58: l_health_plan varchar2(30);
59: l_Handicap per_people_extra_info.pei_information11%type;
60: l_Indiv_Award ghr_pa_request_extra_info.rei_information6%type;
61: --l_locality_pay_area hr_location_extra_info.lei_information4%type;

Line 63: l_Occupation_code ghr_pa_requests.to_occ_code%type;

59: l_Handicap per_people_extra_info.pei_information11%type;
60: l_Indiv_Award ghr_pa_request_extra_info.rei_information6%type;
61: --l_locality_pay_area hr_location_extra_info.lei_information4%type;
62: l_locality_pay_area ghr_locality_pay_areas_f.Locality_Pay_Area_Code%type;
63: l_Occupation_code ghr_pa_requests.to_occ_code%type;
64: -- l_Occupation_code per_position_extra_info.poei_information6%type;
65: l_One_Time_Payment_Amount ghr_pa_requests.AWARD_AMOUNT%type;
66: l_Organ_Component per_position_extra_info.poei_information5%type;
67:

Line 65: l_One_Time_Payment_Amount ghr_pa_requests.AWARD_AMOUNT%type;

61: --l_locality_pay_area hr_location_extra_info.lei_information4%type;
62: l_locality_pay_area ghr_locality_pay_areas_f.Locality_Pay_Area_Code%type;
63: l_Occupation_code ghr_pa_requests.to_occ_code%type;
64: -- l_Occupation_code per_position_extra_info.poei_information6%type;
65: l_One_Time_Payment_Amount ghr_pa_requests.AWARD_AMOUNT%type;
66: l_Organ_Component per_position_extra_info.poei_information5%type;
67:
68: l_pay_rate_determinant_code ghr_pa_requests.PAY_RATE_DETERMINANT%type;
69: l_Personnel_Officer_ID per_position_extra_info.poei_information3%type;

Line 68: l_pay_rate_determinant_code ghr_pa_requests.PAY_RATE_DETERMINANT%type;

64: -- l_Occupation_code per_position_extra_info.poei_information6%type;
65: l_One_Time_Payment_Amount ghr_pa_requests.AWARD_AMOUNT%type;
66: l_Organ_Component per_position_extra_info.poei_information5%type;
67:
68: l_pay_rate_determinant_code ghr_pa_requests.PAY_RATE_DETERMINANT%type;
69: l_Personnel_Officer_ID per_position_extra_info.poei_information3%type;
70: l_Position_Occ_Code ghr_pa_requests.POSITION_OCCUPIED%type;
71: l_Prior_Basic_Pay varchar2(30); -- ghr_pa_requests.FROM_BASIC_PAY%type;
72: -- l_prior_location_id hr_locations.location_id%type

Line 70: l_Position_Occ_Code ghr_pa_requests.POSITION_OCCUPIED%type;

66: l_Organ_Component per_position_extra_info.poei_information5%type;
67:
68: l_pay_rate_determinant_code ghr_pa_requests.PAY_RATE_DETERMINANT%type;
69: l_Personnel_Officer_ID per_position_extra_info.poei_information3%type;
70: l_Position_Occ_Code ghr_pa_requests.POSITION_OCCUPIED%type;
71: l_Prior_Basic_Pay varchar2(30); -- ghr_pa_requests.FROM_BASIC_PAY%type;
72: -- l_prior_location_id hr_locations.location_id%type
73: l_prior_duty_station ghr_duty_stations_f.Duty_Station_Code%type;
74: l_Prior_Grade_Or_Level per_grade_definitions.segment2%type;

Line 71: l_Prior_Basic_Pay varchar2(30); -- ghr_pa_requests.FROM_BASIC_PAY%type;

67:
68: l_pay_rate_determinant_code ghr_pa_requests.PAY_RATE_DETERMINANT%type;
69: l_Personnel_Officer_ID per_position_extra_info.poei_information3%type;
70: l_Position_Occ_Code ghr_pa_requests.POSITION_OCCUPIED%type;
71: l_Prior_Basic_Pay varchar2(30); -- ghr_pa_requests.FROM_BASIC_PAY%type;
72: -- l_prior_location_id hr_locations.location_id%type
73: l_prior_duty_station ghr_duty_stations_f.Duty_Station_Code%type;
74: l_Prior_Grade_Or_Level per_grade_definitions.segment2%type;
75: l_Prior_Locality_Adj varchar2(30); --ghr_pa_requests.FROM_LOCALITY_ADJ%type;

Line 75: l_Prior_Locality_Adj varchar2(30); --ghr_pa_requests.FROM_LOCALITY_ADJ%type;

71: l_Prior_Basic_Pay varchar2(30); -- ghr_pa_requests.FROM_BASIC_PAY%type;
72: -- l_prior_location_id hr_locations.location_id%type
73: l_prior_duty_station ghr_duty_stations_f.Duty_Station_Code%type;
74: l_Prior_Grade_Or_Level per_grade_definitions.segment2%type;
75: l_Prior_Locality_Adj varchar2(30); --ghr_pa_requests.FROM_LOCALITY_ADJ%type;
76: l_prior_locality_pay_area ghr_locality_pay_areas_f.Locality_Pay_Area_Code%type;
77: l_Prior_Occupation_code per_job_definitions.segment1%type;
78: l_Prior_Pay_Basis per_position_extra_info.poei_information6%type;
79: l_Prior_Pay_Plan per_grade_definitions.segment1%type;

Line 82: l_prior_work_schedule_code ghr_pa_requests.WORK_SCHEDULE%type;

78: l_Prior_Pay_Basis per_position_extra_info.poei_information6%type;
79: l_Prior_Pay_Plan per_grade_definitions.segment1%type;
80: l_Prior_Pay_Rate_Det_Code per_assignment_extra_info.aei_information6%type;
81: l_Prior_Step_Or_Rate per_assignment_extra_info.aei_information3%type;
82: l_prior_work_schedule_code ghr_pa_requests.WORK_SCHEDULE%type;
83: l_Production_Date date;
84: l_Race_National_Region per_people_extra_info.pei_information5%type;
85: l_rating_of_record_level ghr_pa_request_extra_info.rei_information5%type;
86: l_rating_of_record_pattern ghr_pa_request_extra_info.rei_information4%type;

Line 93: l_Retirement_Plan_Code ghr_pa_requests.RETIREMENT_PLAN%type;

89: l_retain_grade per_people_extra_info.pei_information3%type;
90: l_retain_pay_plan per_people_extra_info.pei_information5%type;
91: l_retain_step per_people_extra_info.pei_information4%type;
92: l_temp_step per_people_extra_info.pei_information9%type;
93: l_Retirement_Plan_Code ghr_pa_requests.RETIREMENT_PLAN%type;
94: l_Retention_Allowance varchar2(30); -- ghr_pa_requests.TO_RETENTION_ALLOWANCE%type; --number(15,2)
95: l_Second_NOAC_Lookup_code ghr_pa_requests.SECOND_NOA_CODE%type;
96: l_Service_Computation_Date ghr_pa_requests.SERVICE_COMP_DATE%type;
97: l_Sex per_people_f.sex%type;

Line 94: l_Retention_Allowance varchar2(30); -- ghr_pa_requests.TO_RETENTION_ALLOWANCE%type; --number(15,2)

90: l_retain_pay_plan per_people_extra_info.pei_information5%type;
91: l_retain_step per_people_extra_info.pei_information4%type;
92: l_temp_step per_people_extra_info.pei_information9%type;
93: l_Retirement_Plan_Code ghr_pa_requests.RETIREMENT_PLAN%type;
94: l_Retention_Allowance varchar2(30); -- ghr_pa_requests.TO_RETENTION_ALLOWANCE%type; --number(15,2)
95: l_Second_NOAC_Lookup_code ghr_pa_requests.SECOND_NOA_CODE%type;
96: l_Service_Computation_Date ghr_pa_requests.SERVICE_COMP_DATE%type;
97: l_Sex per_people_f.sex%type;
98: l_special_pay_table_id per_position_extra_info.poei_information5%type;

Line 95: l_Second_NOAC_Lookup_code ghr_pa_requests.SECOND_NOA_CODE%type;

91: l_retain_step per_people_extra_info.pei_information4%type;
92: l_temp_step per_people_extra_info.pei_information9%type;
93: l_Retirement_Plan_Code ghr_pa_requests.RETIREMENT_PLAN%type;
94: l_Retention_Allowance varchar2(30); -- ghr_pa_requests.TO_RETENTION_ALLOWANCE%type; --number(15,2)
95: l_Second_NOAC_Lookup_code ghr_pa_requests.SECOND_NOA_CODE%type;
96: l_Service_Computation_Date ghr_pa_requests.SERVICE_COMP_DATE%type;
97: l_Sex per_people_f.sex%type;
98: l_special_pay_table_id per_position_extra_info.poei_information5%type;
99: l_staffing_differential varchar2(30); -- ghr_pa_requests.TO_STAFFING_DIFFERENTIAL%type; --number(15,2)

Line 96: l_Service_Computation_Date ghr_pa_requests.SERVICE_COMP_DATE%type;

92: l_temp_step per_people_extra_info.pei_information9%type;
93: l_Retirement_Plan_Code ghr_pa_requests.RETIREMENT_PLAN%type;
94: l_Retention_Allowance varchar2(30); -- ghr_pa_requests.TO_RETENTION_ALLOWANCE%type; --number(15,2)
95: l_Second_NOAC_Lookup_code ghr_pa_requests.SECOND_NOA_CODE%type;
96: l_Service_Computation_Date ghr_pa_requests.SERVICE_COMP_DATE%type;
97: l_Sex per_people_f.sex%type;
98: l_special_pay_table_id per_position_extra_info.poei_information5%type;
99: l_staffing_differential varchar2(30); -- ghr_pa_requests.TO_STAFFING_DIFFERENTIAL%type; --number(15,2)
100: l_submission_date date;

Line 99: l_staffing_differential varchar2(30); -- ghr_pa_requests.TO_STAFFING_DIFFERENTIAL%type; --number(15,2)

95: l_Second_NOAC_Lookup_code ghr_pa_requests.SECOND_NOA_CODE%type;
96: l_Service_Computation_Date ghr_pa_requests.SERVICE_COMP_DATE%type;
97: l_Sex per_people_f.sex%type;
98: l_special_pay_table_id per_position_extra_info.poei_information5%type;
99: l_staffing_differential varchar2(30); -- ghr_pa_requests.TO_STAFFING_DIFFERENTIAL%type; --number(15,2)
100: l_submission_date date;
101: l_supervisory_differential varchar2(30); -- ghr_pa_requests.TO_SUPERVISORY_DIFFERENTIAL%type; --number(15,2)
102: l_Supervisory_Status_Code ghr_pa_requests.SUPERVISORY_STATUS%type;
103: l_Tenure_Group_Code ghr_pa_requests.TENURE%type;

Line 101: l_supervisory_differential varchar2(30); -- ghr_pa_requests.TO_SUPERVISORY_DIFFERENTIAL%type; --number(15,2)

97: l_Sex per_people_f.sex%type;
98: l_special_pay_table_id per_position_extra_info.poei_information5%type;
99: l_staffing_differential varchar2(30); -- ghr_pa_requests.TO_STAFFING_DIFFERENTIAL%type; --number(15,2)
100: l_submission_date date;
101: l_supervisory_differential varchar2(30); -- ghr_pa_requests.TO_SUPERVISORY_DIFFERENTIAL%type; --number(15,2)
102: l_Supervisory_Status_Code ghr_pa_requests.SUPERVISORY_STATUS%type;
103: l_Tenure_Group_Code ghr_pa_requests.TENURE%type;
104: l_To_Basic_Pay varchar2(30); -- ghr_pa_requests.TO_BASIC_PAY%type;
105: l_To_Grade_Or_Level ghr_pa_requests.TO_GRADE_OR_LEVEL%type;

Line 102: l_Supervisory_Status_Code ghr_pa_requests.SUPERVISORY_STATUS%type;

98: l_special_pay_table_id per_position_extra_info.poei_information5%type;
99: l_staffing_differential varchar2(30); -- ghr_pa_requests.TO_STAFFING_DIFFERENTIAL%type; --number(15,2)
100: l_submission_date date;
101: l_supervisory_differential varchar2(30); -- ghr_pa_requests.TO_SUPERVISORY_DIFFERENTIAL%type; --number(15,2)
102: l_Supervisory_Status_Code ghr_pa_requests.SUPERVISORY_STATUS%type;
103: l_Tenure_Group_Code ghr_pa_requests.TENURE%type;
104: l_To_Basic_Pay varchar2(30); -- ghr_pa_requests.TO_BASIC_PAY%type;
105: l_To_Grade_Or_Level ghr_pa_requests.TO_GRADE_OR_LEVEL%type;
106: l_To_Locality_Adj varchar2(30); -- ghr_pa_requests.TO_LOCALITY_ADJ%type;

Line 103: l_Tenure_Group_Code ghr_pa_requests.TENURE%type;

99: l_staffing_differential varchar2(30); -- ghr_pa_requests.TO_STAFFING_DIFFERENTIAL%type; --number(15,2)
100: l_submission_date date;
101: l_supervisory_differential varchar2(30); -- ghr_pa_requests.TO_SUPERVISORY_DIFFERENTIAL%type; --number(15,2)
102: l_Supervisory_Status_Code ghr_pa_requests.SUPERVISORY_STATUS%type;
103: l_Tenure_Group_Code ghr_pa_requests.TENURE%type;
104: l_To_Basic_Pay varchar2(30); -- ghr_pa_requests.TO_BASIC_PAY%type;
105: l_To_Grade_Or_Level ghr_pa_requests.TO_GRADE_OR_LEVEL%type;
106: l_To_Locality_Adj varchar2(30); -- ghr_pa_requests.TO_LOCALITY_ADJ%type;
107: l_To_Pay_Basis ghr_pa_requests.TO_PAY_BASIS%type;

Line 104: l_To_Basic_Pay varchar2(30); -- ghr_pa_requests.TO_BASIC_PAY%type;

100: l_submission_date date;
101: l_supervisory_differential varchar2(30); -- ghr_pa_requests.TO_SUPERVISORY_DIFFERENTIAL%type; --number(15,2)
102: l_Supervisory_Status_Code ghr_pa_requests.SUPERVISORY_STATUS%type;
103: l_Tenure_Group_Code ghr_pa_requests.TENURE%type;
104: l_To_Basic_Pay varchar2(30); -- ghr_pa_requests.TO_BASIC_PAY%type;
105: l_To_Grade_Or_Level ghr_pa_requests.TO_GRADE_OR_LEVEL%type;
106: l_To_Locality_Adj varchar2(30); -- ghr_pa_requests.TO_LOCALITY_ADJ%type;
107: l_To_Pay_Basis ghr_pa_requests.TO_PAY_BASIS%type;
108: l_To_Pay_Plan ghr_pa_requests.TO_PAY_PLAN%type;

Line 105: l_To_Grade_Or_Level ghr_pa_requests.TO_GRADE_OR_LEVEL%type;

101: l_supervisory_differential varchar2(30); -- ghr_pa_requests.TO_SUPERVISORY_DIFFERENTIAL%type; --number(15,2)
102: l_Supervisory_Status_Code ghr_pa_requests.SUPERVISORY_STATUS%type;
103: l_Tenure_Group_Code ghr_pa_requests.TENURE%type;
104: l_To_Basic_Pay varchar2(30); -- ghr_pa_requests.TO_BASIC_PAY%type;
105: l_To_Grade_Or_Level ghr_pa_requests.TO_GRADE_OR_LEVEL%type;
106: l_To_Locality_Adj varchar2(30); -- ghr_pa_requests.TO_LOCALITY_ADJ%type;
107: l_To_Pay_Basis ghr_pa_requests.TO_PAY_BASIS%type;
108: l_To_Pay_Plan ghr_pa_requests.TO_PAY_PLAN%type;
109: l_To_Pay_Status varchar2(30);

Line 106: l_To_Locality_Adj varchar2(30); -- ghr_pa_requests.TO_LOCALITY_ADJ%type;

102: l_Supervisory_Status_Code ghr_pa_requests.SUPERVISORY_STATUS%type;
103: l_Tenure_Group_Code ghr_pa_requests.TENURE%type;
104: l_To_Basic_Pay varchar2(30); -- ghr_pa_requests.TO_BASIC_PAY%type;
105: l_To_Grade_Or_Level ghr_pa_requests.TO_GRADE_OR_LEVEL%type;
106: l_To_Locality_Adj varchar2(30); -- ghr_pa_requests.TO_LOCALITY_ADJ%type;
107: l_To_Pay_Basis ghr_pa_requests.TO_PAY_BASIS%type;
108: l_To_Pay_Plan ghr_pa_requests.TO_PAY_PLAN%type;
109: l_To_Pay_Status varchar2(30);
110: l_To_Position_ID ghr_pa_requests.TO_Position_ID%type;

Line 107: l_To_Pay_Basis ghr_pa_requests.TO_PAY_BASIS%type;

103: l_Tenure_Group_Code ghr_pa_requests.TENURE%type;
104: l_To_Basic_Pay varchar2(30); -- ghr_pa_requests.TO_BASIC_PAY%type;
105: l_To_Grade_Or_Level ghr_pa_requests.TO_GRADE_OR_LEVEL%type;
106: l_To_Locality_Adj varchar2(30); -- ghr_pa_requests.TO_LOCALITY_ADJ%type;
107: l_To_Pay_Basis ghr_pa_requests.TO_PAY_BASIS%type;
108: l_To_Pay_Plan ghr_pa_requests.TO_PAY_PLAN%type;
109: l_To_Pay_Status varchar2(30);
110: l_To_Position_ID ghr_pa_requests.TO_Position_ID%type;
111: l_To_Step_Or_Rate ghr_pa_requests.TO_STEP_OR_RATE%type;

Line 108: l_To_Pay_Plan ghr_pa_requests.TO_PAY_PLAN%type;

104: l_To_Basic_Pay varchar2(30); -- ghr_pa_requests.TO_BASIC_PAY%type;
105: l_To_Grade_Or_Level ghr_pa_requests.TO_GRADE_OR_LEVEL%type;
106: l_To_Locality_Adj varchar2(30); -- ghr_pa_requests.TO_LOCALITY_ADJ%type;
107: l_To_Pay_Basis ghr_pa_requests.TO_PAY_BASIS%type;
108: l_To_Pay_Plan ghr_pa_requests.TO_PAY_PLAN%type;
109: l_To_Pay_Status varchar2(30);
110: l_To_Position_ID ghr_pa_requests.TO_Position_ID%type;
111: l_To_Step_Or_Rate ghr_pa_requests.TO_STEP_OR_RATE%type;
112: l_rpa_Step_Or_Rate ghr_pa_requests.TO_STEP_OR_RATE%type;

Line 110: l_To_Position_ID ghr_pa_requests.TO_Position_ID%type;

106: l_To_Locality_Adj varchar2(30); -- ghr_pa_requests.TO_LOCALITY_ADJ%type;
107: l_To_Pay_Basis ghr_pa_requests.TO_PAY_BASIS%type;
108: l_To_Pay_Plan ghr_pa_requests.TO_PAY_PLAN%type;
109: l_To_Pay_Status varchar2(30);
110: l_To_Position_ID ghr_pa_requests.TO_Position_ID%type;
111: l_To_Step_Or_Rate ghr_pa_requests.TO_STEP_OR_RATE%type;
112: l_rpa_Step_Or_Rate ghr_pa_requests.TO_STEP_OR_RATE%type;
113: l_Veterans_Preference_Code ghr_pa_requests.VETERANS_PREFERENCE%type;
114: l_Veterans_Status_Code ghr_pa_requests.VETERANS_STATUS%type;

Line 111: l_To_Step_Or_Rate ghr_pa_requests.TO_STEP_OR_RATE%type;

107: l_To_Pay_Basis ghr_pa_requests.TO_PAY_BASIS%type;
108: l_To_Pay_Plan ghr_pa_requests.TO_PAY_PLAN%type;
109: l_To_Pay_Status varchar2(30);
110: l_To_Position_ID ghr_pa_requests.TO_Position_ID%type;
111: l_To_Step_Or_Rate ghr_pa_requests.TO_STEP_OR_RATE%type;
112: l_rpa_Step_Or_Rate ghr_pa_requests.TO_STEP_OR_RATE%type;
113: l_Veterans_Preference_Code ghr_pa_requests.VETERANS_PREFERENCE%type;
114: l_Veterans_Status_Code ghr_pa_requests.VETERANS_STATUS%type;
115: l_work_schedule_code ghr_pa_requests.WORK_SCHEDULE%type;

Line 112: l_rpa_Step_Or_Rate ghr_pa_requests.TO_STEP_OR_RATE%type;

108: l_To_Pay_Plan ghr_pa_requests.TO_PAY_PLAN%type;
109: l_To_Pay_Status varchar2(30);
110: l_To_Position_ID ghr_pa_requests.TO_Position_ID%type;
111: l_To_Step_Or_Rate ghr_pa_requests.TO_STEP_OR_RATE%type;
112: l_rpa_Step_Or_Rate ghr_pa_requests.TO_STEP_OR_RATE%type;
113: l_Veterans_Preference_Code ghr_pa_requests.VETERANS_PREFERENCE%type;
114: l_Veterans_Status_Code ghr_pa_requests.VETERANS_STATUS%type;
115: l_work_schedule_code ghr_pa_requests.WORK_SCHEDULE%type;
116: l_year_degree_attained ghr_pa_requests.YEAR_DEGREE_ATTAINED%type;

Line 113: l_Veterans_Preference_Code ghr_pa_requests.VETERANS_PREFERENCE%type;

109: l_To_Pay_Status varchar2(30);
110: l_To_Position_ID ghr_pa_requests.TO_Position_ID%type;
111: l_To_Step_Or_Rate ghr_pa_requests.TO_STEP_OR_RATE%type;
112: l_rpa_Step_Or_Rate ghr_pa_requests.TO_STEP_OR_RATE%type;
113: l_Veterans_Preference_Code ghr_pa_requests.VETERANS_PREFERENCE%type;
114: l_Veterans_Status_Code ghr_pa_requests.VETERANS_STATUS%type;
115: l_work_schedule_code ghr_pa_requests.WORK_SCHEDULE%type;
116: l_year_degree_attained ghr_pa_requests.YEAR_DEGREE_ATTAINED%type;
117: l_prior_effective_date ghr_pa_requests.effective_date%type;

Line 114: l_Veterans_Status_Code ghr_pa_requests.VETERANS_STATUS%type;

110: l_To_Position_ID ghr_pa_requests.TO_Position_ID%type;
111: l_To_Step_Or_Rate ghr_pa_requests.TO_STEP_OR_RATE%type;
112: l_rpa_Step_Or_Rate ghr_pa_requests.TO_STEP_OR_RATE%type;
113: l_Veterans_Preference_Code ghr_pa_requests.VETERANS_PREFERENCE%type;
114: l_Veterans_Status_Code ghr_pa_requests.VETERANS_STATUS%type;
115: l_work_schedule_code ghr_pa_requests.WORK_SCHEDULE%type;
116: l_year_degree_attained ghr_pa_requests.YEAR_DEGREE_ATTAINED%type;
117: l_prior_effective_date ghr_pa_requests.effective_date%type;
118: l_prior_loc_adj_effective_date ghr_pa_requests.effective_date%type;

Line 115: l_work_schedule_code ghr_pa_requests.WORK_SCHEDULE%type;

111: l_To_Step_Or_Rate ghr_pa_requests.TO_STEP_OR_RATE%type;
112: l_rpa_Step_Or_Rate ghr_pa_requests.TO_STEP_OR_RATE%type;
113: l_Veterans_Preference_Code ghr_pa_requests.VETERANS_PREFERENCE%type;
114: l_Veterans_Status_Code ghr_pa_requests.VETERANS_STATUS%type;
115: l_work_schedule_code ghr_pa_requests.WORK_SCHEDULE%type;
116: l_year_degree_attained ghr_pa_requests.YEAR_DEGREE_ATTAINED%type;
117: l_prior_effective_date ghr_pa_requests.effective_date%type;
118: l_prior_loc_adj_effective_date ghr_pa_requests.effective_date%type;
119: l_session ghr_history_api.g_session_var_type;

Line 116: l_year_degree_attained ghr_pa_requests.YEAR_DEGREE_ATTAINED%type;

112: l_rpa_Step_Or_Rate ghr_pa_requests.TO_STEP_OR_RATE%type;
113: l_Veterans_Preference_Code ghr_pa_requests.VETERANS_PREFERENCE%type;
114: l_Veterans_Status_Code ghr_pa_requests.VETERANS_STATUS%type;
115: l_work_schedule_code ghr_pa_requests.WORK_SCHEDULE%type;
116: l_year_degree_attained ghr_pa_requests.YEAR_DEGREE_ATTAINED%type;
117: l_prior_effective_date ghr_pa_requests.effective_date%type;
118: l_prior_loc_adj_effective_date ghr_pa_requests.effective_date%type;
119: l_session ghr_history_api.g_session_var_type;
120: l_element_entry_value_id pay_element_entry_values_f.element_entry_value_id%type;

Line 117: l_prior_effective_date ghr_pa_requests.effective_date%type;

113: l_Veterans_Preference_Code ghr_pa_requests.VETERANS_PREFERENCE%type;
114: l_Veterans_Status_Code ghr_pa_requests.VETERANS_STATUS%type;
115: l_work_schedule_code ghr_pa_requests.WORK_SCHEDULE%type;
116: l_year_degree_attained ghr_pa_requests.YEAR_DEGREE_ATTAINED%type;
117: l_prior_effective_date ghr_pa_requests.effective_date%type;
118: l_prior_loc_adj_effective_date ghr_pa_requests.effective_date%type;
119: l_session ghr_history_api.g_session_var_type;
120: l_element_entry_value_id pay_element_entry_values_f.element_entry_value_id%type;
121: l_prior_ds_effective_date ghr_pa_requests.effective_date%type;

Line 118: l_prior_loc_adj_effective_date ghr_pa_requests.effective_date%type;

114: l_Veterans_Status_Code ghr_pa_requests.VETERANS_STATUS%type;
115: l_work_schedule_code ghr_pa_requests.WORK_SCHEDULE%type;
116: l_year_degree_attained ghr_pa_requests.YEAR_DEGREE_ATTAINED%type;
117: l_prior_effective_date ghr_pa_requests.effective_date%type;
118: l_prior_loc_adj_effective_date ghr_pa_requests.effective_date%type;
119: l_session ghr_history_api.g_session_var_type;
120: l_element_entry_value_id pay_element_entry_values_f.element_entry_value_id%type;
121: l_prior_ds_effective_date ghr_pa_requests.effective_date%type;
122: ---Bug 5855843

Line 121: l_prior_ds_effective_date ghr_pa_requests.effective_date%type;

117: l_prior_effective_date ghr_pa_requests.effective_date%type;
118: l_prior_loc_adj_effective_date ghr_pa_requests.effective_date%type;
119: l_session ghr_history_api.g_session_var_type;
120: l_element_entry_value_id pay_element_entry_values_f.element_entry_value_id%type;
121: l_prior_ds_effective_date ghr_pa_requests.effective_date%type;
122: ---Bug 5855843
123: l_prior_ds_effective_date_flag BOOLEAN;
124: ---Bug 5855843
125: l_org_structure_id per_position_extra_info.poei_information5%type;

Line 146: from ghr_pa_requests

142:
143: -----Bug 5855843 Start
144: CURSOR cur_ds_prior_date IS
145: select effective_date
146: from ghr_pa_requests
147: where pa_notification_id is not null
148: and person_id = p_pa_request_rec.person_id
149: and effective_date <= p_pa_request_rec.effective_date
150: order by effective_date desc;

Line 229: FROM ghr_pa_requests par

225: AND INFORMATION1 = p_element_entry_value_id -- information1 holds element_entry_value_id
226: AND effective_date <= l_effective_date
227: AND pa_request_id not in
228: (SELECT pa_request_id
229: FROM ghr_pa_requests par
230: WHERE ((par.first_noa_id = l_session.noa_id_correct)
231: OR
232: (par.first_noa_code = '002' and par.second_noa_id = l_session.noa_id_correct))
233: CONNECT BY par.pa_request_id = prior par.altered_pa_request_id

Line 302: from ghr_pa_requests

298:
299: ----------------------------------- cursor to handle changes to LAC codes for Correction to Apptmt action 1274541
300: Cursor c_Corr_LAC_Codes(p_pa_request_id number) is
301: select second_action_la_code1,second_action_la_code2,first_noa_code,second_noa_code
302: from ghr_pa_requests
303: where pa_request_id=p_pa_request_id and first_noa_code='002';
304:
305:
306: Cursor fam_code(p_second_noa_id number) is

Line 322: l_first_noa_code ghr_pa_requests.first_noa_code%type;

318: AND information_type = 'GHR_US_PAR_RG_TEMP_PROMO';
319:
320:
321: ---------------------------------------------------------- added 2 cursors for 1274541
322: l_first_noa_code ghr_pa_requests.first_noa_code%type;
323: l_second_noa_code ghr_pa_requests.second_noa_code%type;
324: l_fam_code ghr_pa_requests.noa_family_code%type;
325:
326: l_pei_count number;

Line 323: l_second_noa_code ghr_pa_requests.second_noa_code%type;

319:
320:
321: ---------------------------------------------------------- added 2 cursors for 1274541
322: l_first_noa_code ghr_pa_requests.first_noa_code%type;
323: l_second_noa_code ghr_pa_requests.second_noa_code%type;
324: l_fam_code ghr_pa_requests.noa_family_code%type;
325:
326: l_pei_count number;
327: l_rei_count number;

Line 324: l_fam_code ghr_pa_requests.noa_family_code%type;

320:
321: ---------------------------------------------------------- added 2 cursors for 1274541
322: l_first_noa_code ghr_pa_requests.first_noa_code%type;
323: l_second_noa_code ghr_pa_requests.second_noa_code%type;
324: l_fam_code ghr_pa_requests.noa_family_code%type;
325:
326: l_pei_count number;
327: l_rei_count number;
328: -- Payroll Integration

Line 350: target_poi ghr_pa_requests.personnel_office_id%type;

346: FROM ghr_pa_request_extra_info
347: WHERE pa_request_id=p_par_id
348: AND information_type='GHR_US_PAR_REALIGNMENT';
349:
350: target_poi ghr_pa_requests.personnel_office_id%type;
351: --
352: -- for bug 3191704
353:
354: --