APPS.PQP_GB_TP_CONTRIBUTION_REPORT dependencies on HRUSERDT

Line 831: l_band_ee_percent := hruserdt.get_table_value(

827: end if;
828:
829: hr_utility.set_location(l_proc||'Annual FTE Rate:'||l_annual_fte_rate, 35);
830:
831: l_band_ee_percent := hruserdt.get_table_value(
832: p_bus_group_id => p_business_group_id,
833: p_table_name => 'PQP_TPA_PENSIONABLE_PAY_RANGE',
834: p_col_name => 'Employee Contribution Rate',
835: p_row_value => to_char(l_annual_fte_rate),

Line 840: l_band_er_percent := hruserdt.get_table_value(

836: p_effective_date => p_date_worked );
837:
838: hr_utility.set_location(l_proc||'EE Percentage:'||l_band_ee_percent, 36);
839:
840: l_band_er_percent := hruserdt.get_table_value(
841: p_bus_group_id => p_business_group_id,
842: p_table_name => 'PQP_TPA_PENSIONABLE_PAY_RANGE',
843: p_col_name => 'Employer Contribution Rate',
844: p_row_value => to_char(l_annual_fte_rate),

Line 849: l_pension_tier := hruserdt.get_table_value(

845: p_effective_date => p_date_worked );
846:
847: hr_utility.set_location(l_proc||'ER Percentage:'||l_band_er_percent, 36);
848:
849: l_pension_tier := hruserdt.get_table_value(
850: p_bus_group_id => p_business_group_id,
851: p_table_name => 'PQP_TPA_PENSIONABLE_PAY_RANGE',
852: p_col_name => 'Pension Tier',
853: p_row_value => to_char(l_annual_fte_rate),