APPS.PY_ZA_TX_UTL_01032013 dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 2690: l_TableValue pay_user_column_instances_f.value%TYPE;

2686: --
2687: l_UserTableID pay_user_tables.user_table_id%TYPE;
2688: l_ColumnID pay_user_columns.user_column_id%TYPE;
2689: l_RowID pay_user_rows_f.user_row_id%TYPE;
2690: l_TableValue pay_user_column_instances_f.value%TYPE;
2691: BEGIN
2692: hr_utility.set_location('py_za_tx_utl_01032013.GetTableValue',1);
2693: -- Get the user_table_id
2694: --

Line 2741: FROM pay_user_column_instances_f pucif

2737: -- Get the value
2738: --
2739: SELECT pucif.value
2740: INTO l_TableValue
2741: FROM pay_user_column_instances_f pucif
2742: where pucif.user_column_id = l_ColumnID
2743: and pucif.user_row_id = l_RowID
2744: AND pucif.legislation_code = 'ZA'
2745: and p_EffectiveDate BETWEEN pucif.effective_start_date

Line 2767: l_fixed pay_user_column_instances_f.value%TYPE;

2763: AS
2764: --
2765: -- Variables
2766: --
2767: l_fixed pay_user_column_instances_f.value%TYPE;
2768: l_limit pay_user_column_instances_f.value%TYPE;
2769: l_percentage pay_user_column_instances_f.value%TYPE;
2770: l_effective_date pay_payroll_actions.effective_date%TYPE;
2771: tax_liability t_Balance;

Line 2768: l_limit pay_user_column_instances_f.value%TYPE;

2764: --
2765: -- Variables
2766: --
2767: l_fixed pay_user_column_instances_f.value%TYPE;
2768: l_limit pay_user_column_instances_f.value%TYPE;
2769: l_percentage pay_user_column_instances_f.value%TYPE;
2770: l_effective_date pay_payroll_actions.effective_date%TYPE;
2771: tax_liability t_Balance;
2772: l_TxbAmt t_Balance;

Line 2769: l_percentage pay_user_column_instances_f.value%TYPE;

2765: -- Variables
2766: --
2767: l_fixed pay_user_column_instances_f.value%TYPE;
2768: l_limit pay_user_column_instances_f.value%TYPE;
2769: l_percentage pay_user_column_instances_f.value%TYPE;
2770: l_effective_date pay_payroll_actions.effective_date%TYPE;
2771: tax_liability t_Balance;
2772: l_TxbAmt t_Balance;
2773: --