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

Line 3033: a := hruserdt.get_table_value (BUSINESS_GROUP_ID, scale, scale||'a', TO_CHAR(EARNING_VALUE), PERIOD_DATE);

3029: end if;
3030:
3031: RETURN msg;
3032: ELSE
3033: a := hruserdt.get_table_value (BUSINESS_GROUP_ID, scale, scale||'a', TO_CHAR(EARNING_VALUE), PERIOD_DATE);
3034: b := hruserdt.get_table_value (BUSINESS_GROUP_ID, scale, scale||'b', TO_CHAR(EARNING_VALUE), PERIOD_DATE);
3035:
3036: if g_debug then
3037: hr_utility.set_location('OUT a '||a,45);

Line 3034: b := hruserdt.get_table_value (BUSINESS_GROUP_ID, scale, scale||'b', TO_CHAR(EARNING_VALUE), PERIOD_DATE);

3030:
3031: RETURN msg;
3032: ELSE
3033: a := hruserdt.get_table_value (BUSINESS_GROUP_ID, scale, scale||'a', TO_CHAR(EARNING_VALUE), PERIOD_DATE);
3034: b := hruserdt.get_table_value (BUSINESS_GROUP_ID, scale, scale||'b', TO_CHAR(EARNING_VALUE), PERIOD_DATE);
3035:
3036: if g_debug then
3037: hr_utility.set_location('OUT a '||a,45);
3038: hr_utility.set_location('OUT b '||b,50);

Line 3963: l_a1 := hruserdt.get_table_value (p_business_group_id, 'FLOOD_LEVY_NO_THRESHOLD', 'FLOOD_LEVY_A', TO_CHAR(l_weekly_fl_earnings), l_pay_effective_date);

3959: l_total_flood_levy := 0;
3960: l_weekly_fl_earnings := pay_au_paye_ff.convert_to_week(p_period_frequency,p_fl_earnings);
3961:
3962: if p_tax_scale = 1 then
3963: l_a1 := hruserdt.get_table_value (p_business_group_id, 'FLOOD_LEVY_NO_THRESHOLD', 'FLOOD_LEVY_A', TO_CHAR(l_weekly_fl_earnings), l_pay_effective_date);
3964: l_b1 := hruserdt.get_table_value (p_business_group_id, 'FLOOD_LEVY_NO_THRESHOLD', 'FLOOD_LEVY_B', TO_CHAR(l_weekly_fl_earnings), l_pay_effective_date);
3965: else
3966: l_a1 := hruserdt.get_table_value (p_business_group_id, 'FLOOD_LEVY_THRESHOLD', 'FLOOD_LEVY_A', TO_CHAR(l_weekly_fl_earnings), l_pay_effective_date);
3967: l_b1 := hruserdt.get_table_value (p_business_group_id, 'FLOOD_LEVY_THRESHOLD', 'FLOOD_LEVY_B', TO_CHAR(l_weekly_fl_earnings), l_pay_effective_date);

Line 3964: l_b1 := hruserdt.get_table_value (p_business_group_id, 'FLOOD_LEVY_NO_THRESHOLD', 'FLOOD_LEVY_B', TO_CHAR(l_weekly_fl_earnings), l_pay_effective_date);

3960: l_weekly_fl_earnings := pay_au_paye_ff.convert_to_week(p_period_frequency,p_fl_earnings);
3961:
3962: if p_tax_scale = 1 then
3963: l_a1 := hruserdt.get_table_value (p_business_group_id, 'FLOOD_LEVY_NO_THRESHOLD', 'FLOOD_LEVY_A', TO_CHAR(l_weekly_fl_earnings), l_pay_effective_date);
3964: l_b1 := hruserdt.get_table_value (p_business_group_id, 'FLOOD_LEVY_NO_THRESHOLD', 'FLOOD_LEVY_B', TO_CHAR(l_weekly_fl_earnings), l_pay_effective_date);
3965: else
3966: l_a1 := hruserdt.get_table_value (p_business_group_id, 'FLOOD_LEVY_THRESHOLD', 'FLOOD_LEVY_A', TO_CHAR(l_weekly_fl_earnings), l_pay_effective_date);
3967: l_b1 := hruserdt.get_table_value (p_business_group_id, 'FLOOD_LEVY_THRESHOLD', 'FLOOD_LEVY_B', TO_CHAR(l_weekly_fl_earnings), l_pay_effective_date);
3968: end if;

Line 3966: l_a1 := hruserdt.get_table_value (p_business_group_id, 'FLOOD_LEVY_THRESHOLD', 'FLOOD_LEVY_A', TO_CHAR(l_weekly_fl_earnings), l_pay_effective_date);

3962: if p_tax_scale = 1 then
3963: l_a1 := hruserdt.get_table_value (p_business_group_id, 'FLOOD_LEVY_NO_THRESHOLD', 'FLOOD_LEVY_A', TO_CHAR(l_weekly_fl_earnings), l_pay_effective_date);
3964: l_b1 := hruserdt.get_table_value (p_business_group_id, 'FLOOD_LEVY_NO_THRESHOLD', 'FLOOD_LEVY_B', TO_CHAR(l_weekly_fl_earnings), l_pay_effective_date);
3965: else
3966: l_a1 := hruserdt.get_table_value (p_business_group_id, 'FLOOD_LEVY_THRESHOLD', 'FLOOD_LEVY_A', TO_CHAR(l_weekly_fl_earnings), l_pay_effective_date);
3967: l_b1 := hruserdt.get_table_value (p_business_group_id, 'FLOOD_LEVY_THRESHOLD', 'FLOOD_LEVY_B', TO_CHAR(l_weekly_fl_earnings), l_pay_effective_date);
3968: end if;
3969:
3970: l_normal_fl_ded := pay_au_paye_ff.calculate_tax

Line 3967: l_b1 := hruserdt.get_table_value (p_business_group_id, 'FLOOD_LEVY_THRESHOLD', 'FLOOD_LEVY_B', TO_CHAR(l_weekly_fl_earnings), l_pay_effective_date);

3963: l_a1 := hruserdt.get_table_value (p_business_group_id, 'FLOOD_LEVY_NO_THRESHOLD', 'FLOOD_LEVY_A', TO_CHAR(l_weekly_fl_earnings), l_pay_effective_date);
3964: l_b1 := hruserdt.get_table_value (p_business_group_id, 'FLOOD_LEVY_NO_THRESHOLD', 'FLOOD_LEVY_B', TO_CHAR(l_weekly_fl_earnings), l_pay_effective_date);
3965: else
3966: l_a1 := hruserdt.get_table_value (p_business_group_id, 'FLOOD_LEVY_THRESHOLD', 'FLOOD_LEVY_A', TO_CHAR(l_weekly_fl_earnings), l_pay_effective_date);
3967: l_b1 := hruserdt.get_table_value (p_business_group_id, 'FLOOD_LEVY_THRESHOLD', 'FLOOD_LEVY_B', TO_CHAR(l_weekly_fl_earnings), l_pay_effective_date);
3968: end if;
3969:
3970: l_normal_fl_ded := pay_au_paye_ff.calculate_tax
3971: (p_date_earned

Line 4040: l_a2 := hruserdt.get_table_value (p_business_group_id, 'FLOOD_LEVY_NO_THRESHOLD', 'FLOOD_LEVY_A', TO_CHAR(l_combined_weekly_fl_earnings), l_pay_effective_date);

4036: l_combined_fl_earnings := p_fl_earnings + TRUNC(l_entry_value_tab(i)/l_spread_over);
4037: l_combined_weekly_fl_earnings := pay_au_paye_ff.convert_to_week(p_period_frequency,l_combined_fl_earnings);
4038:
4039: if p_tax_scale = 1 then
4040: l_a2 := hruserdt.get_table_value (p_business_group_id, 'FLOOD_LEVY_NO_THRESHOLD', 'FLOOD_LEVY_A', TO_CHAR(l_combined_weekly_fl_earnings), l_pay_effective_date);
4041: l_b2 := hruserdt.get_table_value (p_business_group_id, 'FLOOD_LEVY_NO_THRESHOLD', 'FLOOD_LEVY_B', TO_CHAR(l_combined_weekly_fl_earnings), l_pay_effective_date);
4042: else
4043: l_a2 := hruserdt.get_table_value (p_business_group_id, 'FLOOD_LEVY_THRESHOLD', 'FLOOD_LEVY_A', TO_CHAR(l_combined_weekly_fl_earnings), l_pay_effective_date);
4044: l_b2 := hruserdt.get_table_value (p_business_group_id, 'FLOOD_LEVY_THRESHOLD', 'FLOOD_LEVY_B', TO_CHAR(l_combined_weekly_fl_earnings), l_pay_effective_date);

Line 4041: l_b2 := hruserdt.get_table_value (p_business_group_id, 'FLOOD_LEVY_NO_THRESHOLD', 'FLOOD_LEVY_B', TO_CHAR(l_combined_weekly_fl_earnings), l_pay_effective_date);

4037: l_combined_weekly_fl_earnings := pay_au_paye_ff.convert_to_week(p_period_frequency,l_combined_fl_earnings);
4038:
4039: if p_tax_scale = 1 then
4040: l_a2 := hruserdt.get_table_value (p_business_group_id, 'FLOOD_LEVY_NO_THRESHOLD', 'FLOOD_LEVY_A', TO_CHAR(l_combined_weekly_fl_earnings), l_pay_effective_date);
4041: l_b2 := hruserdt.get_table_value (p_business_group_id, 'FLOOD_LEVY_NO_THRESHOLD', 'FLOOD_LEVY_B', TO_CHAR(l_combined_weekly_fl_earnings), l_pay_effective_date);
4042: else
4043: l_a2 := hruserdt.get_table_value (p_business_group_id, 'FLOOD_LEVY_THRESHOLD', 'FLOOD_LEVY_A', TO_CHAR(l_combined_weekly_fl_earnings), l_pay_effective_date);
4044: l_b2 := hruserdt.get_table_value (p_business_group_id, 'FLOOD_LEVY_THRESHOLD', 'FLOOD_LEVY_B', TO_CHAR(l_combined_weekly_fl_earnings), l_pay_effective_date);
4045: end if;

Line 4043: l_a2 := hruserdt.get_table_value (p_business_group_id, 'FLOOD_LEVY_THRESHOLD', 'FLOOD_LEVY_A', TO_CHAR(l_combined_weekly_fl_earnings), l_pay_effective_date);

4039: if p_tax_scale = 1 then
4040: l_a2 := hruserdt.get_table_value (p_business_group_id, 'FLOOD_LEVY_NO_THRESHOLD', 'FLOOD_LEVY_A', TO_CHAR(l_combined_weekly_fl_earnings), l_pay_effective_date);
4041: l_b2 := hruserdt.get_table_value (p_business_group_id, 'FLOOD_LEVY_NO_THRESHOLD', 'FLOOD_LEVY_B', TO_CHAR(l_combined_weekly_fl_earnings), l_pay_effective_date);
4042: else
4043: l_a2 := hruserdt.get_table_value (p_business_group_id, 'FLOOD_LEVY_THRESHOLD', 'FLOOD_LEVY_A', TO_CHAR(l_combined_weekly_fl_earnings), l_pay_effective_date);
4044: l_b2 := hruserdt.get_table_value (p_business_group_id, 'FLOOD_LEVY_THRESHOLD', 'FLOOD_LEVY_B', TO_CHAR(l_combined_weekly_fl_earnings), l_pay_effective_date);
4045: end if;
4046:
4047: l_combined_fl_ded := pay_au_paye_ff.calculate_tax

Line 4044: l_b2 := hruserdt.get_table_value (p_business_group_id, 'FLOOD_LEVY_THRESHOLD', 'FLOOD_LEVY_B', TO_CHAR(l_combined_weekly_fl_earnings), l_pay_effective_date);

4040: l_a2 := hruserdt.get_table_value (p_business_group_id, 'FLOOD_LEVY_NO_THRESHOLD', 'FLOOD_LEVY_A', TO_CHAR(l_combined_weekly_fl_earnings), l_pay_effective_date);
4041: l_b2 := hruserdt.get_table_value (p_business_group_id, 'FLOOD_LEVY_NO_THRESHOLD', 'FLOOD_LEVY_B', TO_CHAR(l_combined_weekly_fl_earnings), l_pay_effective_date);
4042: else
4043: l_a2 := hruserdt.get_table_value (p_business_group_id, 'FLOOD_LEVY_THRESHOLD', 'FLOOD_LEVY_A', TO_CHAR(l_combined_weekly_fl_earnings), l_pay_effective_date);
4044: l_b2 := hruserdt.get_table_value (p_business_group_id, 'FLOOD_LEVY_THRESHOLD', 'FLOOD_LEVY_B', TO_CHAR(l_combined_weekly_fl_earnings), l_pay_effective_date);
4045: end if;
4046:
4047: l_combined_fl_ded := pay_au_paye_ff.calculate_tax
4048: (p_date_earned