APPS.PY_ZA_TX_UTL_01032007 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_01032007.GetTableValue',1);
2043: -- Get the user_table_id
2044: --

Line 2091: FROM pay_user_column_instances_f pucif

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

Line 2117: l_fixed pay_user_column_instances_f.value%TYPE;

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

Line 2118: l_limit pay_user_column_instances_f.value%TYPE;

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

Line 2119: l_percentage pay_user_column_instances_f.value%TYPE;

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