APPS.PY_ZA_TX_UTL_01032011 dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 2593: l_TableValue pay_user_column_instances_f.value%TYPE;

2589: --
2590: l_UserTableID pay_user_tables.user_table_id%TYPE;
2591: l_ColumnID pay_user_columns.user_column_id%TYPE;
2592: l_RowID pay_user_rows_f.user_row_id%TYPE;
2593: l_TableValue pay_user_column_instances_f.value%TYPE;
2594: BEGIN
2595: hr_utility.set_location('py_za_tx_utl_01032011.GetTableValue',1);
2596: -- Get the user_table_id
2597: --

Line 2644: FROM pay_user_column_instances_f pucif

2640: -- Get the value
2641: --
2642: SELECT pucif.value
2643: INTO l_TableValue
2644: FROM pay_user_column_instances_f pucif
2645: where pucif.user_column_id = l_ColumnID
2646: and pucif.user_row_id = l_RowID
2647: AND pucif.legislation_code = 'ZA'
2648: and p_EffectiveDate BETWEEN pucif.effective_start_date

Line 2670: l_fixed pay_user_column_instances_f.value%TYPE;

2666: AS
2667: --
2668: -- Variables
2669: --
2670: l_fixed pay_user_column_instances_f.value%TYPE;
2671: l_limit pay_user_column_instances_f.value%TYPE;
2672: l_percentage pay_user_column_instances_f.value%TYPE;
2673: l_effective_date pay_payroll_actions.effective_date%TYPE;
2674: tax_liability t_Balance;

Line 2671: l_limit pay_user_column_instances_f.value%TYPE;

2667: --
2668: -- Variables
2669: --
2670: l_fixed pay_user_column_instances_f.value%TYPE;
2671: l_limit pay_user_column_instances_f.value%TYPE;
2672: l_percentage pay_user_column_instances_f.value%TYPE;
2673: l_effective_date pay_payroll_actions.effective_date%TYPE;
2674: tax_liability t_Balance;
2675: l_TxbAmt t_Balance;

Line 2672: l_percentage pay_user_column_instances_f.value%TYPE;

2668: -- Variables
2669: --
2670: l_fixed pay_user_column_instances_f.value%TYPE;
2671: l_limit pay_user_column_instances_f.value%TYPE;
2672: l_percentage pay_user_column_instances_f.value%TYPE;
2673: l_effective_date pay_payroll_actions.effective_date%TYPE;
2674: tax_liability t_Balance;
2675: l_TxbAmt t_Balance;
2676: --