APPS.PY_ZA_TX_UTL_01032006 dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 2040: l_TableValue pay_user_column_instances_f.value%TYPE;

2036: --
2037: l_UserTableID pay_user_tables.user_table_id%TYPE;
2038: l_ColumnID pay_user_columns.user_column_id%TYPE;
2039: l_RowID pay_user_rows_f.user_row_id%TYPE;
2040: l_TableValue pay_user_column_instances_f.value%TYPE;
2041: BEGIN
2042: hr_utility.set_location('py_za_tx_utl_01032006.GetTableValue',1);
2043: -- Get the user_table_id
2044: --

Line 2089: FROM pay_user_column_instances_f pucif

2085: -- Get the value
2086: --
2087: SELECT pucif.value
2088: INTO l_TableValue
2089: FROM pay_user_column_instances_f pucif
2090: where pucif.user_column_id = l_ColumnID
2091: and pucif.user_row_id = l_RowID
2092: AND pucif.legislation_code = 'ZA'
2093: and p_EffectiveDate BETWEEN pucif.effective_start_date

Line 2115: l_fixed pay_user_column_instances_f.value%TYPE;

2111: AS
2112: --
2113: -- Variables
2114: --
2115: l_fixed pay_user_column_instances_f.value%TYPE;
2116: l_limit pay_user_column_instances_f.value%TYPE;
2117: l_percentage pay_user_column_instances_f.value%TYPE;
2118: l_effective_date pay_payroll_actions.effective_date%TYPE;
2119: tax_liability t_Balance;

Line 2116: l_limit pay_user_column_instances_f.value%TYPE;

2112: --
2113: -- Variables
2114: --
2115: l_fixed pay_user_column_instances_f.value%TYPE;
2116: l_limit pay_user_column_instances_f.value%TYPE;
2117: l_percentage pay_user_column_instances_f.value%TYPE;
2118: l_effective_date pay_payroll_actions.effective_date%TYPE;
2119: tax_liability t_Balance;
2120: l_TxbAmt t_Balance;

Line 2117: l_percentage pay_user_column_instances_f.value%TYPE;

2113: -- Variables
2114: --
2115: l_fixed pay_user_column_instances_f.value%TYPE;
2116: l_limit pay_user_column_instances_f.value%TYPE;
2117: l_percentage pay_user_column_instances_f.value%TYPE;
2118: l_effective_date pay_payroll_actions.effective_date%TYPE;
2119: tax_liability t_Balance;
2120: l_TxbAmt t_Balance;
2121: --