1855: --
1856: l_UserTableID pay_user_tables.user_table_id%TYPE;
1857: l_ColumnID pay_user_columns.user_column_id%TYPE;
1858: l_RowID pay_user_rows_f.user_row_id%TYPE;
1859: l_TableValue pay_user_column_instances_f.value%TYPE;
1860: BEGIN
1861: hr_utility.set_location('py_za_tx_utl_01032002.GetTableValue',1);
1862: -- Get the user_table_id
1863: --
1904: -- Get the value
1905: --
1906: SELECT pucif.value
1907: INTO l_TableValue
1908: FROM pay_user_column_instances_f pucif
1909: where pucif.user_column_id = l_ColumnID
1910: and pucif.user_row_id = l_RowID
1911: AND pucif.legislation_code = 'ZA'
1912: and p_EffectiveDate BETWEEN pucif.effective_start_date
1930: AS
1931:
1932: -- Variables
1933: --
1934: l_fixed pay_user_column_instances_f.value%TYPE;
1935: l_limit pay_user_column_instances_f.value%TYPE;
1936: l_percentage pay_user_column_instances_f.value%TYPE;
1937: l_effective_date pay_payroll_actions.effective_date%TYPE;
1938: tax_liability t_Balance;
1931:
1932: -- Variables
1933: --
1934: l_fixed pay_user_column_instances_f.value%TYPE;
1935: l_limit pay_user_column_instances_f.value%TYPE;
1936: l_percentage pay_user_column_instances_f.value%TYPE;
1937: l_effective_date pay_payroll_actions.effective_date%TYPE;
1938: tax_liability t_Balance;
1939: l_TxbAmt t_Balance;
1932: -- Variables
1933: --
1934: l_fixed pay_user_column_instances_f.value%TYPE;
1935: l_limit pay_user_column_instances_f.value%TYPE;
1936: l_percentage pay_user_column_instances_f.value%TYPE;
1937: l_effective_date pay_payroll_actions.effective_date%TYPE;
1938: tax_liability t_Balance;
1939: l_TxbAmt t_Balance;
1940: