APPS.PY_ZA_TX_UTL_01032005 dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 1913: l_TableValue pay_user_column_instances_f.value%TYPE;

1909: --
1910: l_UserTableID pay_user_tables.user_table_id%TYPE;
1911: l_ColumnID pay_user_columns.user_column_id%TYPE;
1912: l_RowID pay_user_rows_f.user_row_id%TYPE;
1913: l_TableValue pay_user_column_instances_f.value%TYPE;
1914: BEGIN
1915: hr_utility.set_location('py_za_tx_utl_01032005.GetTableValue',1);
1916: -- Get the user_table_id
1917: --

Line 1962: FROM pay_user_column_instances_f pucif

1958: -- Get the value
1959: --
1960: SELECT pucif.value
1961: INTO l_TableValue
1962: FROM pay_user_column_instances_f pucif
1963: where pucif.user_column_id = l_ColumnID
1964: and pucif.user_row_id = l_RowID
1965: AND pucif.legislation_code = 'ZA'
1966: and p_EffectiveDate BETWEEN pucif.effective_start_date

Line 1988: l_fixed pay_user_column_instances_f.value%TYPE;

1984: AS
1985:
1986: -- Variables
1987: --
1988: l_fixed pay_user_column_instances_f.value%TYPE;
1989: l_limit pay_user_column_instances_f.value%TYPE;
1990: l_percentage pay_user_column_instances_f.value%TYPE;
1991: l_effective_date pay_payroll_actions.effective_date%TYPE;
1992: tax_liability t_Balance;

Line 1989: l_limit pay_user_column_instances_f.value%TYPE;

1985:
1986: -- Variables
1987: --
1988: l_fixed pay_user_column_instances_f.value%TYPE;
1989: l_limit pay_user_column_instances_f.value%TYPE;
1990: l_percentage pay_user_column_instances_f.value%TYPE;
1991: l_effective_date pay_payroll_actions.effective_date%TYPE;
1992: tax_liability t_Balance;
1993: l_TxbAmt t_Balance;

Line 1990: l_percentage pay_user_column_instances_f.value%TYPE;

1986: -- Variables
1987: --
1988: l_fixed pay_user_column_instances_f.value%TYPE;
1989: l_limit pay_user_column_instances_f.value%TYPE;
1990: l_percentage pay_user_column_instances_f.value%TYPE;
1991: l_effective_date pay_payroll_actions.effective_date%TYPE;
1992: tax_liability t_Balance;
1993: l_TxbAmt t_Balance;
1994: