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.PAY_FR_SICKNESS_CALC dependencies on HRUSERDT

Line 63: -- Replaced local UDT function with hruserdt

59: -- 05-11-02 115.46 autiwari Revoked 115.45 changes and corrected Get_sickness_skip to
60: -- return correct previous duration (spclly long absences)
61: -- 06-11-02 115.51 autiwari Modified Calc_IJSS for retrieving rates throughout the absence duration
62: -- when duration crosses the boundary days for bug #2651295
63: -- Replaced local UDT function with hruserdt
64: -- 07-11-02 115.52 autiwari Bugfix 2659924:Commented out IJSS Ineligibility Mssg
65: -- PAY_75021_ABS_INELIG_FOR_IJSS
66: -- 07-11-02 115.57 autiwari Bugfix 2651568:Zero divisor for ppl hired on 1st day of mth
67: -- 08-11-02 115.60 autiwari Bugfix 2661851:2nd absence in period has incorrect days processed in guarantee

Line 1130: l_delay_days := hruserdt.get_table_value(p_business_group_id,

1126: hr_utility.trace(' l_maternity_related:'||(l_maternity_related));
1127: -- subtract the ones already covered in the previous period or
1128: -- previous linked/parent absence
1129: if l_maternity_related = 'N' then
1130: l_delay_days := hruserdt.get_table_value(p_business_group_id,
1131: 'FR_IJSS_NON_OCCUP_RATES_MAX','Delay',
1132: p_absence_duration+1,l_ref_start_dt);
1133: else l_delay_days := 0;
1134: end if;

Line 1175: l_ijss_rate := hruserdt.get_table_value(p_business_group_id,'FR_IJSS_NON_OCCUP_RATES_MAX','Rate for others (%)',l_count_ijss_loop,l_abs_start_date);

1171: -- (ii) retrieve rates if required
1172: -- according to the number of dependents
1173: hr_utility.set_location('Absence duration boundary for non-occup :'||to_char(l_count_ijss_loop),22);
1174: IF l_dependent_count<3 THEN
1175: l_ijss_rate := hruserdt.get_table_value(p_business_group_id,'FR_IJSS_NON_OCCUP_RATES_MAX','Rate for others (%)',l_count_ijss_loop,l_abs_start_date);
1176: l_max_rate := hruserdt.get_table_value(p_business_group_id,'FR_IJSS_NON_OCCUP_RATES_MAX','Max for others - Related to annual SS ceiling',l_count_ijss_loop,l_abs_start_date);
1177: l_min_rate := hruserdt.get_table_value(p_business_group_id,'FR_IJSS_NON_OCCUP_RATES_MAX','Min for others:Factor of global minimal invalidity pension',l_count_ijss_loop,l_abs_start_date);
1178: ELSE
1179: l_ijss_rate := hruserdt.get_table_value(p_business_group_id,'FR_IJSS_NON_OCCUP_RATES_MAX','Rate for 3 dependents or more (%)',l_count_ijss_loop,l_abs_start_date);

Line 1176: l_max_rate := hruserdt.get_table_value(p_business_group_id,'FR_IJSS_NON_OCCUP_RATES_MAX','Max for others - Related to annual SS ceiling',l_count_ijss_loop,l_abs_start_date);

1172: -- according to the number of dependents
1173: hr_utility.set_location('Absence duration boundary for non-occup :'||to_char(l_count_ijss_loop),22);
1174: IF l_dependent_count<3 THEN
1175: l_ijss_rate := hruserdt.get_table_value(p_business_group_id,'FR_IJSS_NON_OCCUP_RATES_MAX','Rate for others (%)',l_count_ijss_loop,l_abs_start_date);
1176: l_max_rate := hruserdt.get_table_value(p_business_group_id,'FR_IJSS_NON_OCCUP_RATES_MAX','Max for others - Related to annual SS ceiling',l_count_ijss_loop,l_abs_start_date);
1177: l_min_rate := hruserdt.get_table_value(p_business_group_id,'FR_IJSS_NON_OCCUP_RATES_MAX','Min for others:Factor of global minimal invalidity pension',l_count_ijss_loop,l_abs_start_date);
1178: ELSE
1179: l_ijss_rate := hruserdt.get_table_value(p_business_group_id,'FR_IJSS_NON_OCCUP_RATES_MAX','Rate for 3 dependents or more (%)',l_count_ijss_loop,l_abs_start_date);
1180: l_max_rate := hruserdt.get_table_value(p_business_group_id,'FR_IJSS_NON_OCCUP_RATES_MAX','Max for 3 dependents or more - Related to annual SS ceiling',l_count_ijss_loop,l_abs_start_date);

Line 1177: l_min_rate := hruserdt.get_table_value(p_business_group_id,'FR_IJSS_NON_OCCUP_RATES_MAX','Min for others:Factor of global minimal invalidity pension',l_count_ijss_loop,l_abs_start_date);

1173: hr_utility.set_location('Absence duration boundary for non-occup :'||to_char(l_count_ijss_loop),22);
1174: IF l_dependent_count<3 THEN
1175: l_ijss_rate := hruserdt.get_table_value(p_business_group_id,'FR_IJSS_NON_OCCUP_RATES_MAX','Rate for others (%)',l_count_ijss_loop,l_abs_start_date);
1176: l_max_rate := hruserdt.get_table_value(p_business_group_id,'FR_IJSS_NON_OCCUP_RATES_MAX','Max for others - Related to annual SS ceiling',l_count_ijss_loop,l_abs_start_date);
1177: l_min_rate := hruserdt.get_table_value(p_business_group_id,'FR_IJSS_NON_OCCUP_RATES_MAX','Min for others:Factor of global minimal invalidity pension',l_count_ijss_loop,l_abs_start_date);
1178: ELSE
1179: l_ijss_rate := hruserdt.get_table_value(p_business_group_id,'FR_IJSS_NON_OCCUP_RATES_MAX','Rate for 3 dependents or more (%)',l_count_ijss_loop,l_abs_start_date);
1180: l_max_rate := hruserdt.get_table_value(p_business_group_id,'FR_IJSS_NON_OCCUP_RATES_MAX','Max for 3 dependents or more - Related to annual SS ceiling',l_count_ijss_loop,l_abs_start_date);
1181: l_min_rate := hruserdt.get_table_value(p_business_group_id,'FR_IJSS_NON_OCCUP_RATES_MAX','Min for 3 dependents or more:Factor of global minimal invalidity pension',l_count_ijss_loop,l_abs_start_date);

Line 1179: l_ijss_rate := hruserdt.get_table_value(p_business_group_id,'FR_IJSS_NON_OCCUP_RATES_MAX','Rate for 3 dependents or more (%)',l_count_ijss_loop,l_abs_start_date);

1175: l_ijss_rate := hruserdt.get_table_value(p_business_group_id,'FR_IJSS_NON_OCCUP_RATES_MAX','Rate for others (%)',l_count_ijss_loop,l_abs_start_date);
1176: l_max_rate := hruserdt.get_table_value(p_business_group_id,'FR_IJSS_NON_OCCUP_RATES_MAX','Max for others - Related to annual SS ceiling',l_count_ijss_loop,l_abs_start_date);
1177: l_min_rate := hruserdt.get_table_value(p_business_group_id,'FR_IJSS_NON_OCCUP_RATES_MAX','Min for others:Factor of global minimal invalidity pension',l_count_ijss_loop,l_abs_start_date);
1178: ELSE
1179: l_ijss_rate := hruserdt.get_table_value(p_business_group_id,'FR_IJSS_NON_OCCUP_RATES_MAX','Rate for 3 dependents or more (%)',l_count_ijss_loop,l_abs_start_date);
1180: l_max_rate := hruserdt.get_table_value(p_business_group_id,'FR_IJSS_NON_OCCUP_RATES_MAX','Max for 3 dependents or more - Related to annual SS ceiling',l_count_ijss_loop,l_abs_start_date);
1181: l_min_rate := hruserdt.get_table_value(p_business_group_id,'FR_IJSS_NON_OCCUP_RATES_MAX','Min for 3 dependents or more:Factor of global minimal invalidity pension',l_count_ijss_loop,l_abs_start_date);
1182: END IF;
1183: END IF;

Line 1180: l_max_rate := hruserdt.get_table_value(p_business_group_id,'FR_IJSS_NON_OCCUP_RATES_MAX','Max for 3 dependents or more - Related to annual SS ceiling',l_count_ijss_loop,l_abs_start_date);

1176: l_max_rate := hruserdt.get_table_value(p_business_group_id,'FR_IJSS_NON_OCCUP_RATES_MAX','Max for others - Related to annual SS ceiling',l_count_ijss_loop,l_abs_start_date);
1177: l_min_rate := hruserdt.get_table_value(p_business_group_id,'FR_IJSS_NON_OCCUP_RATES_MAX','Min for others:Factor of global minimal invalidity pension',l_count_ijss_loop,l_abs_start_date);
1178: ELSE
1179: l_ijss_rate := hruserdt.get_table_value(p_business_group_id,'FR_IJSS_NON_OCCUP_RATES_MAX','Rate for 3 dependents or more (%)',l_count_ijss_loop,l_abs_start_date);
1180: l_max_rate := hruserdt.get_table_value(p_business_group_id,'FR_IJSS_NON_OCCUP_RATES_MAX','Max for 3 dependents or more - Related to annual SS ceiling',l_count_ijss_loop,l_abs_start_date);
1181: l_min_rate := hruserdt.get_table_value(p_business_group_id,'FR_IJSS_NON_OCCUP_RATES_MAX','Min for 3 dependents or more:Factor of global minimal invalidity pension',l_count_ijss_loop,l_abs_start_date);
1182: END IF;
1183: END IF;
1184: hr_utility.set_location('ijss rate:'||to_char(l_ijss_rate)||' max rate:'||to_char(l_max_rate)||' min rate:'||to_char(l_min_rate),22);

Line 1181: l_min_rate := hruserdt.get_table_value(p_business_group_id,'FR_IJSS_NON_OCCUP_RATES_MAX','Min for 3 dependents or more:Factor of global minimal invalidity pension',l_count_ijss_loop,l_abs_start_date);

1177: l_min_rate := hruserdt.get_table_value(p_business_group_id,'FR_IJSS_NON_OCCUP_RATES_MAX','Min for others:Factor of global minimal invalidity pension',l_count_ijss_loop,l_abs_start_date);
1178: ELSE
1179: l_ijss_rate := hruserdt.get_table_value(p_business_group_id,'FR_IJSS_NON_OCCUP_RATES_MAX','Rate for 3 dependents or more (%)',l_count_ijss_loop,l_abs_start_date);
1180: l_max_rate := hruserdt.get_table_value(p_business_group_id,'FR_IJSS_NON_OCCUP_RATES_MAX','Max for 3 dependents or more - Related to annual SS ceiling',l_count_ijss_loop,l_abs_start_date);
1181: l_min_rate := hruserdt.get_table_value(p_business_group_id,'FR_IJSS_NON_OCCUP_RATES_MAX','Min for 3 dependents or more:Factor of global minimal invalidity pension',l_count_ijss_loop,l_abs_start_date);
1182: END IF;
1183: END IF;
1184: hr_utility.set_location('ijss rate:'||to_char(l_ijss_rate)||' max rate:'||to_char(l_max_rate)||' min rate:'||to_char(l_min_rate),22);
1185: -- (iii) calculate IJSS

Line 1292: l_delay_days := hruserdt.get_table_value(p_business_group_id,'FR_IJSS_OCCUP_RATES_MAX','Delay',p_absence_duration+1,l_ref_start_dt);

1288: END IF;
1289: END LOOP;
1290: CLOSE csr_row_value;
1291:
1292: l_delay_days := hruserdt.get_table_value(p_business_group_id,'FR_IJSS_OCCUP_RATES_MAX','Delay',p_absence_duration+1,l_ref_start_dt);
1293:
1294:
1295: FOR l_count_ijss_loop IN (p_absence_duration+1)..(p_absence_duration+l_total_overlap_rows) LOOP
1296: --

Line 1305: l_ijss_rate := hruserdt.get_table_value(p_business_group_id,'FR_IJSS_OCCUP_RATES_MAX','Rate (%)',l_count_ijss_loop,l_abs_start_date);

1301: IF l_count_ijss_loop =p_absence_duration+1 OR -- first time
1302: l_count_ijss_loop = l_lower_range_value(2).l_boundary_value THEN
1303: -- (ii) retrieve rates if required
1304: hr_utility.set_location('Absence duration boundary for occup :'||to_char(l_count_ijss_loop),22);
1305: l_ijss_rate := hruserdt.get_table_value(p_business_group_id,'FR_IJSS_OCCUP_RATES_MAX','Rate (%)',l_count_ijss_loop,l_abs_start_date);
1306: l_max_rate := hruserdt.get_table_value(p_business_group_id,'FR_IJSS_OCCUP_RATES_MAX','Max - Related to annual SS ceiling',l_count_ijss_loop,l_abs_start_date);
1307: END IF;
1308: hr_utility.set_location('ijss rate:'||to_char(l_ijss_rate)||' max rate:'||to_char(l_max_rate),22);
1309: -- (iii) calculate IJSS

Line 1306: l_max_rate := hruserdt.get_table_value(p_business_group_id,'FR_IJSS_OCCUP_RATES_MAX','Max - Related to annual SS ceiling',l_count_ijss_loop,l_abs_start_date);

1302: l_count_ijss_loop = l_lower_range_value(2).l_boundary_value THEN
1303: -- (ii) retrieve rates if required
1304: hr_utility.set_location('Absence duration boundary for occup :'||to_char(l_count_ijss_loop),22);
1305: l_ijss_rate := hruserdt.get_table_value(p_business_group_id,'FR_IJSS_OCCUP_RATES_MAX','Rate (%)',l_count_ijss_loop,l_abs_start_date);
1306: l_max_rate := hruserdt.get_table_value(p_business_group_id,'FR_IJSS_OCCUP_RATES_MAX','Max - Related to annual SS ceiling',l_count_ijss_loop,l_abs_start_date);
1307: END IF;
1308: hr_utility.set_location('ijss rate:'||to_char(l_ijss_rate)||' max rate:'||to_char(l_max_rate),22);
1309: -- (iii) calculate IJSS
1310: -- the maximum daily salary

Line 1460: l_smid_rate := hruserdt.get_table_value(p_business_group_id,'FR_CONTRIBUTION_RATES','Value (EUR)','EE_SMID',l_ref_bal_date_from);

1456: OPEN csr_global_value('FR_HOURLY_SMIC_RATE',l_ref_bal_date_from);
1457: FETCH csr_global_value INTO l_smic_hourly_rate;
1458: CLOSE csr_global_value;
1459: --
1460: l_smid_rate := hruserdt.get_table_value(p_business_group_id,'FR_CONTRIBUTION_RATES','Value (EUR)','EE_SMID',l_ref_bal_date_from);
1461: --
1462: l_global_smic_ded := l_smic_multiplier * l_smic_hourly_rate * l_smid_rate / 100;
1463: IF l_smid_6_mths > l_global_smic_ded THEN
1464: l_short_term_elig_flg := 'Y';

Line 1498: l_smid_rate := hruserdt.get_table_value(p_business_group_id,'FR_CONTRIBUTION_RATES','Value (EUR)','EE_SMID',l_ref_bal_date_from);

1494: OPEN csr_global_value('FR_HOURLY_SMIC_RATE',l_ref_bal_date_from);
1495: FETCH csr_global_value INTO l_smic_hourly_rate;
1496: CLOSE csr_global_value;
1497: --
1498: l_smid_rate := hruserdt.get_table_value(p_business_group_id,'FR_CONTRIBUTION_RATES','Value (EUR)','EE_SMID',l_ref_bal_date_from);
1499: --
1500: l_global_smic_ded := 2 * (l_smic_multiplier * l_smic_hourly_rate * l_smid_rate / 100);
1501: IF l_smid_12_mths > l_global_smic_ded THEN
1502: l_long_term_elig_flg := 'Y';

Line 3287: l_waiting_days := hruserdt.get_table_value(l_business_group_id,

3283: l_svc_in_years := 0;
3284: END;
3285:
3286: -- Waiting days check
3287: l_waiting_days := hruserdt.get_table_value(l_business_group_id,
3288: 'FR_LEGI_WAITING_DAYS',
3289: 'DAYS_DELAY',
3290: l_work_incident_type,
3291: l_parent_absence_start_date);

Line 3305: l_B1_days := hruserdt.get_table_value(l_business_group_id,

3301: l_gi_start_date := l_gi_start_date + l_curr_waiting_days;
3302: END IF;
3303:
3304: -- Get Bands information from Range UDT
3305: l_B1_days := hruserdt.get_table_value(l_business_group_id,
3306: 'FR_LEGI_RATE_BANDS',
3307: 'DAYS_AT_HIGH_RATE',
3308: l_svc_in_years,
3309: l_parent_absence_start_date);

Line 3311: l_B2_days := hruserdt.get_table_value(l_business_group_id,

3307: 'DAYS_AT_HIGH_RATE',
3308: l_svc_in_years,
3309: l_parent_absence_start_date);
3310:
3311: l_B2_days := hruserdt.get_table_value(l_business_group_id,
3312: 'FR_LEGI_RATE_BANDS',
3313: 'DAYS_AT_LOW_RATE',
3314: l_svc_in_years,
3315: l_parent_absence_start_date);

Line 3317: l_B1_prcnt := hruserdt.get_table_value(l_business_group_id,

3313: 'DAYS_AT_LOW_RATE',
3314: l_svc_in_years,
3315: l_parent_absence_start_date);
3316:
3317: l_B1_prcnt := hruserdt.get_table_value(l_business_group_id,
3318: 'FR_LEGI_RATE_BANDS',
3319: 'HIGH_RATE(%)',
3320: l_svc_in_years,
3321: l_parent_absence_start_date);

Line 3323: l_B2_prcnt := hruserdt.get_table_value(l_business_group_id,

3319: 'HIGH_RATE(%)',
3320: l_svc_in_years,
3321: l_parent_absence_start_date);
3322:
3323: l_B2_prcnt := hruserdt.get_table_value(l_business_group_id,
3324: 'FR_LEGI_RATE_BANDS',
3325: 'LOW_RATE(%)',
3326: l_svc_in_years,
3327: l_parent_absence_start_date);