APPS.PY_ZA_TX_UTL_01032009 dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 2578: l_TableValue pay_user_column_instances_f.value%TYPE;

2574: --
2575: l_UserTableID pay_user_tables.user_table_id%TYPE;
2576: l_ColumnID pay_user_columns.user_column_id%TYPE;
2577: l_RowID pay_user_rows_f.user_row_id%TYPE;
2578: l_TableValue pay_user_column_instances_f.value%TYPE;
2579: BEGIN
2580: hr_utility.set_location('py_za_tx_utl_01032009.GetTableValue',1);
2581: -- Get the user_table_id
2582: --

Line 2629: FROM pay_user_column_instances_f pucif

2625: -- Get the value
2626: --
2627: SELECT pucif.value
2628: INTO l_TableValue
2629: FROM pay_user_column_instances_f pucif
2630: where pucif.user_column_id = l_ColumnID
2631: and pucif.user_row_id = l_RowID
2632: AND pucif.legislation_code = 'ZA'
2633: and p_EffectiveDate BETWEEN pucif.effective_start_date

Line 2655: l_fixed pay_user_column_instances_f.value%TYPE;

2651: AS
2652: --
2653: -- Variables
2654: --
2655: l_fixed pay_user_column_instances_f.value%TYPE;
2656: l_limit pay_user_column_instances_f.value%TYPE;
2657: l_percentage pay_user_column_instances_f.value%TYPE;
2658: l_effective_date pay_payroll_actions.effective_date%TYPE;
2659: tax_liability t_Balance;

Line 2656: l_limit pay_user_column_instances_f.value%TYPE;

2652: --
2653: -- Variables
2654: --
2655: l_fixed pay_user_column_instances_f.value%TYPE;
2656: l_limit pay_user_column_instances_f.value%TYPE;
2657: l_percentage pay_user_column_instances_f.value%TYPE;
2658: l_effective_date pay_payroll_actions.effective_date%TYPE;
2659: tax_liability t_Balance;
2660: l_TxbAmt t_Balance;

Line 2657: l_percentage pay_user_column_instances_f.value%TYPE;

2653: -- Variables
2654: --
2655: l_fixed pay_user_column_instances_f.value%TYPE;
2656: l_limit pay_user_column_instances_f.value%TYPE;
2657: l_percentage pay_user_column_instances_f.value%TYPE;
2658: l_effective_date pay_payroll_actions.effective_date%TYPE;
2659: tax_liability t_Balance;
2660: l_TxbAmt t_Balance;
2661: --