APPS.PY_ZA_TX_UTL_01032004 dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 2373: l_TableValue pay_user_column_instances_f.value%TYPE;

2369: --
2370: l_UserTableID pay_user_tables.user_table_id%TYPE;
2371: l_ColumnID pay_user_columns.user_column_id%TYPE;
2372: l_RowID pay_user_rows_f.user_row_id%TYPE;
2373: l_TableValue pay_user_column_instances_f.value%TYPE;
2374: BEGIN
2375: hr_utility.set_location('py_za_tx_utl_01032004.GetTableValue',1);
2376: -- Get the user_table_id
2377: --

Line 2422: FROM pay_user_column_instances_f pucif

2418: -- Get the value
2419: --
2420: SELECT pucif.value
2421: INTO l_TableValue
2422: FROM pay_user_column_instances_f pucif
2423: where pucif.user_column_id = l_ColumnID
2424: and pucif.user_row_id = l_RowID
2425: AND pucif.legislation_code = 'ZA'
2426: and p_EffectiveDate BETWEEN pucif.effective_start_date

Line 2448: l_fixed pay_user_column_instances_f.value%TYPE;

2444: AS
2445:
2446: -- Variables
2447: --
2448: l_fixed pay_user_column_instances_f.value%TYPE;
2449: l_limit pay_user_column_instances_f.value%TYPE;
2450: l_percentage pay_user_column_instances_f.value%TYPE;
2451: l_effective_date pay_payroll_actions.effective_date%TYPE;
2452: tax_liability t_Balance;

Line 2449: l_limit pay_user_column_instances_f.value%TYPE;

2445:
2446: -- Variables
2447: --
2448: l_fixed pay_user_column_instances_f.value%TYPE;
2449: l_limit pay_user_column_instances_f.value%TYPE;
2450: l_percentage pay_user_column_instances_f.value%TYPE;
2451: l_effective_date pay_payroll_actions.effective_date%TYPE;
2452: tax_liability t_Balance;
2453: l_TxbAmt t_Balance;

Line 2450: l_percentage pay_user_column_instances_f.value%TYPE;

2446: -- Variables
2447: --
2448: l_fixed pay_user_column_instances_f.value%TYPE;
2449: l_limit pay_user_column_instances_f.value%TYPE;
2450: l_percentage pay_user_column_instances_f.value%TYPE;
2451: l_effective_date pay_payroll_actions.effective_date%TYPE;
2452: tax_liability t_Balance;
2453: l_TxbAmt t_Balance;
2454: