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_KR_FF_FUNCTIONS_PKG dependencies on HRUSERDT

Line 3506: l_addend := to_number(hruserdt.get_table_value(

3502:
3503: begin
3504: l_svpd_income_exem := 0;
3505: if (p_service_period - p_overlap_period) > 0 then
3506: l_addend := to_number(hruserdt.get_table_value(
3507: p_bus_group_id => p_business_group_id,
3508: p_table_name => 'SVPD_INCOME_EXEM',
3509: p_col_name => 'ADDEND',
3510: p_row_value => to_char(p_service_period - p_overlap_period),

Line 3512: l_multiplier := to_number(hruserdt.get_table_value(

3508: p_table_name => 'SVPD_INCOME_EXEM',
3509: p_col_name => 'ADDEND',
3510: p_row_value => to_char(p_service_period - p_overlap_period),
3511: p_effective_date => p_effective_date));
3512: l_multiplier := to_number(hruserdt.get_table_value(
3513: p_bus_group_id => p_business_group_id,
3514: p_table_name => 'SVPD_INCOME_EXEM',
3515: p_col_name => 'MULTIPLIER',
3516: p_row_value => to_char(p_service_period - p_overlap_period),

Line 3518: l_subtrahend := to_number(hruserdt.get_table_value(

3514: p_table_name => 'SVPD_INCOME_EXEM',
3515: p_col_name => 'MULTIPLIER',
3516: p_row_value => to_char(p_service_period - p_overlap_period),
3517: p_effective_date => p_effective_date));
3518: l_subtrahend := to_number(hruserdt.get_table_value(
3519: p_bus_group_id => p_business_group_id,
3520: p_table_name => 'SVPD_INCOME_EXEM',
3521: p_col_name => 'SUBTRAHEND',
3522: p_row_value => to_char(p_service_period - p_overlap_period),

Line 3551: l_multiplier := to_number(hruserdt.get_table_value(

3547: l_ycalc_tax := 0;
3548: l_calc_tax := 0;
3549: l_sep_calc_tax := 0;
3550: if l_taxation_base > 0 then
3551: l_multiplier := to_number(hruserdt.get_table_value(
3552: p_bus_group_id => p_business_group_id,
3553: p_table_name => 'CALC_TAX',
3554: p_col_name => 'MULTIPLIER',
3555: p_row_value => to_char(l_taxation_base),

Line 3557: l_subtrahend := to_number(hruserdt.get_table_value(

3553: p_table_name => 'CALC_TAX',
3554: p_col_name => 'MULTIPLIER',
3555: p_row_value => to_char(l_taxation_base),
3556: p_effective_date => p_effective_date));
3557: l_subtrahend := to_number(hruserdt.get_table_value(
3558: p_bus_group_id => p_business_group_id,
3559: p_table_name => 'CALC_TAX',
3560: p_col_name => 'SUBTRAHEND',
3561: p_row_value => to_char(l_taxation_base),

Line 3650: l_addend := to_number(hruserdt.get_table_value(

3646: l_svpd_income_exem := 0;
3647:
3648:
3649: if (p_service_period - p_st_overlap_period) > 0 then
3650: l_addend := to_number(hruserdt.get_table_value(
3651: p_bus_group_id => p_business_group_id,
3652: p_table_name => 'SVPD_INCOME_EXEM',
3653: p_col_name => 'ADDEND',
3654: p_row_value => to_char(p_service_period - p_st_overlap_period),

Line 3656: l_multiplier := to_number(hruserdt.get_table_value(

3652: p_table_name => 'SVPD_INCOME_EXEM',
3653: p_col_name => 'ADDEND',
3654: p_row_value => to_char(p_service_period - p_st_overlap_period),
3655: p_effective_date => p_effective_date));
3656: l_multiplier := to_number(hruserdt.get_table_value(
3657: p_bus_group_id => p_business_group_id,
3658: p_table_name => 'SVPD_INCOME_EXEM',
3659: p_col_name => 'MULTIPLIER',
3660: p_row_value => to_char(p_service_period - p_st_overlap_period),

Line 3662: l_subtrahend := to_number(hruserdt.get_table_value(

3658: p_table_name => 'SVPD_INCOME_EXEM',
3659: p_col_name => 'MULTIPLIER',
3660: p_row_value => to_char(p_service_period - p_st_overlap_period),
3661: p_effective_date => p_effective_date));
3662: l_subtrahend := to_number(hruserdt.get_table_value(
3663: p_bus_group_id => p_business_group_id,
3664: p_table_name => 'SVPD_INCOME_EXEM',
3665: p_col_name => 'SUBTRAHEND',
3666: p_row_value => to_char(p_service_period - p_st_overlap_period),

Line 3710: l_nst_addend := to_number(hruserdt.get_table_value(

3706: else
3707: l_nst_int_service_period := (p_nst_service_period - p_nst_overlap_period) - l_nst_st_service_period ;
3708: end if;
3709: /* Deductions for entire working Period */
3710: l_nst_addend := to_number(hruserdt.get_table_value(
3711: p_bus_group_id => p_business_group_id,
3712: p_table_name => 'SVPD_INCOME_EXEM',
3713: p_col_name => 'ADDEND',
3714: p_row_value => to_char(p_nst_service_period - p_nst_overlap_period),

Line 3716: l_nst_multiplier := to_number(hruserdt.get_table_value(

3712: p_table_name => 'SVPD_INCOME_EXEM',
3713: p_col_name => 'ADDEND',
3714: p_row_value => to_char(p_nst_service_period - p_nst_overlap_period),
3715: p_effective_date => p_effective_date));
3716: l_nst_multiplier := to_number(hruserdt.get_table_value(
3717: p_bus_group_id => p_business_group_id,
3718: p_table_name => 'SVPD_INCOME_EXEM',
3719: p_col_name => 'MULTIPLIER',
3720: p_row_value => to_char(p_nst_service_period - p_nst_overlap_period),

Line 3722: l_nst_subtrahend := to_number(hruserdt.get_table_value(

3718: p_table_name => 'SVPD_INCOME_EXEM',
3719: p_col_name => 'MULTIPLIER',
3720: p_row_value => to_char(p_nst_service_period - p_nst_overlap_period),
3721: p_effective_date => p_effective_date));
3722: l_nst_subtrahend := to_number(hruserdt.get_table_value(
3723: p_bus_group_id => p_business_group_id,
3724: p_table_name => 'SVPD_INCOME_EXEM',
3725: p_col_name => 'SUBTRAHEND',
3726: p_row_value => to_char(p_nst_service_period - p_nst_overlap_period),

Line 3730: l_nst_addend := to_number(hruserdt.get_table_value(

3726: p_row_value => to_char(p_nst_service_period - p_nst_overlap_period),
3727: p_effective_date => p_effective_date));
3728: l_nst_ent_svpd_income_exem := l_nst_addend + trunc(l_nst_multiplier * ((p_nst_service_period - p_nst_overlap_period) - l_nst_subtrahend));
3729: /* Deductions for the working period of interim separation pay */
3730: l_nst_addend := to_number(hruserdt.get_table_value(
3731: p_bus_group_id => p_business_group_id,
3732: p_table_name => 'SVPD_INCOME_EXEM',
3733: p_col_name => 'ADDEND',
3734: p_row_value => to_char(l_nst_int_service_period),

Line 3736: l_nst_multiplier := to_number(hruserdt.get_table_value(

3732: p_table_name => 'SVPD_INCOME_EXEM',
3733: p_col_name => 'ADDEND',
3734: p_row_value => to_char(l_nst_int_service_period),
3735: p_effective_date => p_effective_date));
3736: l_nst_multiplier := to_number(hruserdt.get_table_value(
3737: p_bus_group_id => p_business_group_id,
3738: p_table_name => 'SVPD_INCOME_EXEM',
3739: p_col_name => 'MULTIPLIER',
3740: p_row_value => to_char(l_nst_int_service_period),

Line 3742: l_nst_subtrahend := to_number(hruserdt.get_table_value(

3738: p_table_name => 'SVPD_INCOME_EXEM',
3739: p_col_name => 'MULTIPLIER',
3740: p_row_value => to_char(l_nst_int_service_period),
3741: p_effective_date => p_effective_date));
3742: l_nst_subtrahend := to_number(hruserdt.get_table_value(
3743: p_bus_group_id => p_business_group_id,
3744: p_table_name => 'SVPD_INCOME_EXEM',
3745: p_col_name => 'SUBTRAHEND',
3746: p_row_value => to_char(l_nst_int_service_period),

Line 3750: l_nst_addend := to_number(hruserdt.get_table_value(

3746: p_row_value => to_char(l_nst_int_service_period),
3747: p_effective_date => p_effective_date));
3748: l_nst_int_svpd_income_exem := l_nst_addend + trunc(l_nst_multiplier * (l_nst_int_service_period - l_nst_subtrahend));
3749: /* Deductions for the working period of statutory separation pay */
3750: l_nst_addend := to_number(hruserdt.get_table_value(
3751: p_bus_group_id => p_business_group_id,
3752: p_table_name => 'SVPD_INCOME_EXEM',
3753: p_col_name => 'ADDEND',
3754: p_row_value => to_char(l_nst_st_service_period),

Line 3757: l_nst_multiplier := to_number(hruserdt.get_table_value(

3753: p_col_name => 'ADDEND',
3754: p_row_value => to_char(l_nst_st_service_period),
3755: p_effective_date => p_effective_date));
3756:
3757: l_nst_multiplier := to_number(hruserdt.get_table_value(
3758: p_bus_group_id => p_business_group_id,
3759: p_table_name => 'SVPD_INCOME_EXEM',
3760: p_col_name => 'MULTIPLIER',
3761: p_row_value => to_char(l_nst_st_service_period),

Line 3764: l_nst_subtrahend := to_number(hruserdt.get_table_value(

3760: p_col_name => 'MULTIPLIER',
3761: p_row_value => to_char(l_nst_st_service_period),
3762: p_effective_date => p_effective_date));
3763:
3764: l_nst_subtrahend := to_number(hruserdt.get_table_value(
3765: p_bus_group_id => p_business_group_id,
3766: p_table_name => 'SVPD_INCOME_EXEM',
3767: p_col_name => 'SUBTRAHEND',
3768: p_row_value => to_char(l_nst_st_service_period),

Line 3797: l_tot_multiplier := to_number(hruserdt.get_table_value(

3793: l_total_taxation_base := l_taxation_base + l_nst_taxation_base;
3794: /* Total yearly calculated tax */
3795: l_total_ycalc_tax := 0;
3796: if l_total_taxation_base > 0 then
3797: l_tot_multiplier := to_number(hruserdt.get_table_value(
3798: p_bus_group_id => p_business_group_id,
3799: p_table_name => 'CALC_TAX',
3800: p_col_name => 'MULTIPLIER',
3801: p_row_value => to_char(l_total_taxation_base),

Line 3804: l_tot_subtrahend := to_number(hruserdt.get_table_value(

3800: p_col_name => 'MULTIPLIER',
3801: p_row_value => to_char(l_total_taxation_base),
3802: p_effective_date => p_effective_date));
3803:
3804: l_tot_subtrahend := to_number(hruserdt.get_table_value(
3805: p_bus_group_id => p_business_group_id,
3806: p_table_name => 'CALC_TAX',
3807: p_col_name => 'SUBTRAHEND',
3808: p_row_value => to_char(l_total_taxation_base),