DBA Data[Home] [Help]

APPS.GHR_LACS_REMARKS dependencies on GHR_PAY_CALC

Line 24: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;

20: p_pa_request_id ghr_pa_requests.pa_request_id%TYPE)
21: IS
22: l_grade_id per_grades.grade_id%TYPE;
23: l_assignment_id per_assignments_f.assignment_id%TYPE;
24: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
25: l_multi_error_flag boolean;
26: cursor c_grade_kff (grd_id number) is
27: select gdf.segment1
28: ,gdf.segment2

Line 48: WHEN ghr_pay_calc.pay_calc_message THEN

44: l_retained_grade_rec := ghr_pc_basic_pay.get_retained_grade_details
45: ( g_requests_rec.person_id,
46: g_requests_rec.effective_date);
47: EXCEPTION
48: WHEN ghr_pay_calc.pay_calc_message THEN
49: NULL;
50: END;
51: -- Bug#4901888
52:

Line 57: g_pay_table_id := SUBSTR(ghr_pay_calc.get_user_table_name(

53: IF l_retained_grade_rec.pay_plan IS NOT NULL THEN
54: g_step_or_rate := l_retained_grade_rec.step_or_rate;
55: g_pay_plan := l_retained_grade_rec.pay_plan;
56: g_grade_or_level := l_retained_grade_rec.grade_or_level;
57: g_pay_table_id := SUBSTR(ghr_pay_calc.get_user_table_name(
58: l_retained_grade_rec.user_table_id), 1, 4);
59: ELSE
60: l_location := 'Apply_894_Rules:Fetch_Data:Fetching Assignments';
61: SELECT paf.assignment_id, paf.grade_id

Line 87: g_pay_table_id := SUBSTR(ghr_pay_calc.get_user_table_name(

83: (p_position_id => g_position_id,
84: p_information_type => 'GHR_US_POS_VALID_GRADE',
85: p_date_effective => g_requests_rec.effective_date,
86: p_pos_ei_data => l_pos_extra_info_rec);
87: g_pay_table_id := SUBSTR(ghr_pay_calc.get_user_table_name(
88: l_pos_extra_info_rec.poei_information5), 1, 4);
89: END IF;
90: hr_utility.set_location('Pay Table ID Bef Calc Pay Table'||g_pay_table_id,10);
91: -- Bug#4901888 Added the following IF condition to consider the Calculation

Line 95: g_pay_table_id := SUBSTR(ghr_pay_calc.get_user_table_name(

91: -- Bug#4901888 Added the following IF condition to consider the Calculation
92: -- pay table to determine the LAC/Remarks.(using TO PAY TABLE ID
93: -- AS IT HOLDS THE CALC PAY TABLE ID).
94: IF g_requests_rec.to_pay_table_identifier IS NOT NULL THEN
95: g_pay_table_id := SUBSTR(ghr_pay_calc.get_user_table_name(
96: g_requests_rec.to_pay_table_identifier), 1, 4);
97: END IF;
98: hr_utility.set_location('Pay Table ID Aft Calc Pay Table'||g_pay_table_id,50);
99: -- Bug#4901888 End

Line 346: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'

342: l_la_code1 := 'VWZ';
343:
344: l_adj_bp := g_requests_rec.from_adj_basic_pay;
345:
346: l_pay_cap_amount := ghr_pay_calc.get_standard_pay_table_value('EX'
347: ,'02'
348: ,'00'
349: ,g_requests_rec.effective_date);
350: