APPS.PAY_SE_TAX_TABLE_UPLOAD dependencies on PAY_RANGE_TEMP

Line 164: DELETE FROM pay_range_temp;

160: );
161:
162: IF p_effective_start_date IS NULL AND p_effective_end_date IS NULL
163: THEN
164: DELETE FROM pay_range_temp;
165: ELSE
166: OPEN csr_legislation_code;
167:
168: FETCH csr_legislation_code

Line 296: FROM pay_range_temp;

292: IS
293: SELECT DISTINCT range_table_number
294: ,period_frequency
295: ,row_value_uom
296: FROM pay_range_temp;
297:
298: CURSOR csr_range_band_val_frm_tmp_tab (
299: l_range_table_num NUMBER
300: ,l_period_frequency VARCHAR2

Line 314: FROM pay_range_temp

310: ,amount5
311: ,amount6
312: ,amount7
313: ,amount8
314: FROM pay_range_temp
315: WHERE range_table_number = l_range_table_num
316: AND period_frequency = l_period_frequency
317: AND row_value_uom = l_row_value_uom;
318:

Line 566: -- variables which represents columns in PAY_RANGE_TEMP table.

562: l_line_read VARCHAR2 (4000) := NULL;
563: -- Batch Variables
564: l_batch_seq NUMBER := 0;
565: l_batch_id NUMBER;
566: -- variables which represents columns in PAY_RANGE_TEMP table.
567: l_range_table_number pay_range_tables_f.range_table_number%TYPE;
568: l_period_frequency pay_range_tables_f.period_frequency%TYPE;
569: l_row_value_uom pay_range_tables_f.row_value_uom%TYPE;
570: l_low_band pay_ranges_f.low_band%TYPE;

Line 629: INSERT INTO pay_range_temp

625: );
626: -- Warning record is of different frequency Type
627: IF (trim(l_period_frequency) = trim(p_tax_table_type))
628: THEN
629: INSERT INTO pay_range_temp
630: (range_id
631: ,range_table_number
632: ,row_value_uom
633: ,period_frequency