APPS.PY_ZA_TX_UTL_01032012 dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 2638: l_TableValue pay_user_column_instances_f.value%TYPE;

2634: --
2635: l_UserTableID pay_user_tables.user_table_id%TYPE;
2636: l_ColumnID pay_user_columns.user_column_id%TYPE;
2637: l_RowID pay_user_rows_f.user_row_id%TYPE;
2638: l_TableValue pay_user_column_instances_f.value%TYPE;
2639: BEGIN
2640: hr_utility.set_location('py_za_tx_utl_01032012.GetTableValue',1);
2641: -- Get the user_table_id
2642: --

Line 2689: FROM pay_user_column_instances_f pucif

2685: -- Get the value
2686: --
2687: SELECT pucif.value
2688: INTO l_TableValue
2689: FROM pay_user_column_instances_f pucif
2690: where pucif.user_column_id = l_ColumnID
2691: and pucif.user_row_id = l_RowID
2692: AND pucif.legislation_code = 'ZA'
2693: and p_EffectiveDate BETWEEN pucif.effective_start_date

Line 2715: l_fixed pay_user_column_instances_f.value%TYPE;

2711: AS
2712: --
2713: -- Variables
2714: --
2715: l_fixed pay_user_column_instances_f.value%TYPE;
2716: l_limit pay_user_column_instances_f.value%TYPE;
2717: l_percentage pay_user_column_instances_f.value%TYPE;
2718: l_effective_date pay_payroll_actions.effective_date%TYPE;
2719: tax_liability t_Balance;

Line 2716: l_limit pay_user_column_instances_f.value%TYPE;

2712: --
2713: -- Variables
2714: --
2715: l_fixed pay_user_column_instances_f.value%TYPE;
2716: l_limit pay_user_column_instances_f.value%TYPE;
2717: l_percentage pay_user_column_instances_f.value%TYPE;
2718: l_effective_date pay_payroll_actions.effective_date%TYPE;
2719: tax_liability t_Balance;
2720: l_TxbAmt t_Balance;

Line 2717: l_percentage pay_user_column_instances_f.value%TYPE;

2713: -- Variables
2714: --
2715: l_fixed pay_user_column_instances_f.value%TYPE;
2716: l_limit pay_user_column_instances_f.value%TYPE;
2717: l_percentage pay_user_column_instances_f.value%TYPE;
2718: l_effective_date pay_payroll_actions.effective_date%TYPE;
2719: tax_liability t_Balance;
2720: l_TxbAmt t_Balance;
2721: --