eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_SE_TAX_TABLE_UPLOAD dependencies on PAY_RANGE_TABLES_F

Line 129: FROM pay_range_tables_f

125: )
126: IS
127: SELECT range_table_id
128: ,object_version_number
129: FROM pay_range_tables_f
130: WHERE legislation_code = p_legislation_code
131: --AND BUSINESS_GROUP_ID = p_business_group
132: AND effective_start_date >=
133: TO_DATE (p_effective_start_date, 'YYYY/MM/DD HH24:MI:SS')

Line 226: l_pay_f_range_table_id pay_range_tables_f.range_table_id%TYPE;

222: IS
223: l_proc CONSTANT VARCHAR2 (72)
224: := g_package || '.Upload_Tax_To_Main_Table';
225: -- Automatic Sequence created by API
226: l_pay_f_range_table_id pay_range_tables_f.range_table_id%TYPE;
227: -- Values from flat file to be uploaded to Temp Tables
228: l_range_table_num pay_range_tables_f.range_table_number%TYPE;
229: l_period_frequency pay_range_tables_f.period_frequency%TYPE;
230: l_row_value_uom pay_range_tables_f.row_value_uom%TYPE;

Line 228: l_range_table_num pay_range_tables_f.range_table_number%TYPE;

224: := g_package || '.Upload_Tax_To_Main_Table';
225: -- Automatic Sequence created by API
226: l_pay_f_range_table_id pay_range_tables_f.range_table_id%TYPE;
227: -- Values from flat file to be uploaded to Temp Tables
228: l_range_table_num pay_range_tables_f.range_table_number%TYPE;
229: l_period_frequency pay_range_tables_f.period_frequency%TYPE;
230: l_row_value_uom pay_range_tables_f.row_value_uom%TYPE;
231: l_low_band pay_ranges_f.low_band%TYPE;
232: l_high_band pay_ranges_f.high_band%TYPE;

Line 229: l_period_frequency pay_range_tables_f.period_frequency%TYPE;

225: -- Automatic Sequence created by API
226: l_pay_f_range_table_id pay_range_tables_f.range_table_id%TYPE;
227: -- Values from flat file to be uploaded to Temp Tables
228: l_range_table_num pay_range_tables_f.range_table_number%TYPE;
229: l_period_frequency pay_range_tables_f.period_frequency%TYPE;
230: l_row_value_uom pay_range_tables_f.row_value_uom%TYPE;
231: l_low_band pay_ranges_f.low_band%TYPE;
232: l_high_band pay_ranges_f.high_band%TYPE;
233: l_amount1 pay_ranges_f.amount1%TYPE;

Line 230: l_row_value_uom pay_range_tables_f.row_value_uom%TYPE;

226: l_pay_f_range_table_id pay_range_tables_f.range_table_id%TYPE;
227: -- Values from flat file to be uploaded to Temp Tables
228: l_range_table_num pay_range_tables_f.range_table_number%TYPE;
229: l_period_frequency pay_range_tables_f.period_frequency%TYPE;
230: l_row_value_uom pay_range_tables_f.row_value_uom%TYPE;
231: l_low_band pay_ranges_f.low_band%TYPE;
232: l_high_band pay_ranges_f.high_band%TYPE;
233: l_amount1 pay_ranges_f.amount1%TYPE;
234: l_amount2 pay_ranges_f.amount2%TYPE;

Line 241: l_dummy_range_table_id pay_range_tables_f.range_table_id%TYPE;

237: l_amount5 pay_ranges_f.amount5%TYPE;
238: l_amount6 pay_ranges_f.amount6%TYPE;
239: l_amount7 pay_ranges_f.amount7%TYPE;
240: l_amount8 pay_ranges_f.amount8%TYPE;
241: l_dummy_range_table_id pay_range_tables_f.range_table_id%TYPE;
242: l_object_version_number pay_range_tables_f.object_version_number%TYPE;
243: l_dummy pay_range_tables_f.object_version_number%TYPE;
244: l_csr_range_table_id pay_range_tables_f.range_table_id%TYPE;
245:

Line 242: l_object_version_number pay_range_tables_f.object_version_number%TYPE;

238: l_amount6 pay_ranges_f.amount6%TYPE;
239: l_amount7 pay_ranges_f.amount7%TYPE;
240: l_amount8 pay_ranges_f.amount8%TYPE;
241: l_dummy_range_table_id pay_range_tables_f.range_table_id%TYPE;
242: l_object_version_number pay_range_tables_f.object_version_number%TYPE;
243: l_dummy pay_range_tables_f.object_version_number%TYPE;
244: l_csr_range_table_id pay_range_tables_f.range_table_id%TYPE;
245:
246: CURSOR csr_data_exists_on_same_date

Line 243: l_dummy pay_range_tables_f.object_version_number%TYPE;

239: l_amount7 pay_ranges_f.amount7%TYPE;
240: l_amount8 pay_ranges_f.amount8%TYPE;
241: l_dummy_range_table_id pay_range_tables_f.range_table_id%TYPE;
242: l_object_version_number pay_range_tables_f.object_version_number%TYPE;
243: l_dummy pay_range_tables_f.object_version_number%TYPE;
244: l_csr_range_table_id pay_range_tables_f.range_table_id%TYPE;
245:
246: CURSOR csr_data_exists_on_same_date
247: IS

Line 244: l_csr_range_table_id pay_range_tables_f.range_table_id%TYPE;

240: l_amount8 pay_ranges_f.amount8%TYPE;
241: l_dummy_range_table_id pay_range_tables_f.range_table_id%TYPE;
242: l_object_version_number pay_range_tables_f.object_version_number%TYPE;
243: l_dummy pay_range_tables_f.object_version_number%TYPE;
244: l_csr_range_table_id pay_range_tables_f.range_table_id%TYPE;
245:
246: CURSOR csr_data_exists_on_same_date
247: IS
248: SELECT 'Y'

Line 249: FROM pay_range_tables_f

245:
246: CURSOR csr_data_exists_on_same_date
247: IS
248: SELECT 'Y'
249: FROM pay_range_tables_f
250: WHERE legislation_code = p_legislation_code
251: AND period_frequency = p_tax_table_type
252: --AND BUSINESS_GROUP_ID = p_business_group
253: AND effective_start_date = p_effective_start_date;

Line 260: FROM pay_range_tables_f

256: IS
257: SELECT 'Y'
258: ,effective_start_date
259: ,effective_end_date
260: FROM pay_range_tables_f
261: WHERE legislation_code = p_legislation_code
262: AND period_frequency = p_tax_table_type
263: --AND BUSINESS_GROUP_ID = p_business_group
264: AND effective_start_date > p_effective_start_date;

Line 274: FROM pay_range_tables_f

270: )
271: IS
272: SELECT range_table_id
273: ,object_version_number
274: FROM pay_range_tables_f
275: WHERE legislation_code = p_legislation_code
276: --AND BUSINESS_GROUP_ID = p_business_group
277: AND effective_start_date < p_effective_start_date
278: AND range_table_number = l_range_table_number

Line 325: FROM pay_range_tables_f

321: SELECT range_table_id
322: ,range_table_number
323: ,period_frequency
324: ,row_value_uom
325: FROM pay_range_tables_f
326: WHERE legislation_code = p_legislation_code
327: --AND BUSINESS_GROUP_ID = p_business_group
328: AND effective_start_date = p_effective_start_date
329: AND effective_end_date = c_end_of_time;

Line 423: -- For each record in the pay_range_tables_f

419: -- Open Master parent table and fetch the range_table_num , Period_frequency and row value num
420: -- pick up values from temp table for this record and insert that in to Main child table
421: FOR MASTER IN csr_range_values_from_main_tab
422: LOOP
423: -- For each record in the pay_range_tables_f
424: -- pick up all record one by one from pay_ranges_temp
425: -- and insert into pay_ranges_f table
426: FOR CHILD IN
427: csr_range_band_val_frm_tmp_tab (MASTER.range_table_number

Line 502: l_object_version_number pay_range_tables_f.object_version_number%TYPE;

498: AND effective_start_date < p_effective_start_date
499: AND effective_end_date = c_end_of_time;
500:
501: l_range_id NUMBER;
502: l_object_version_number pay_range_tables_f.object_version_number%TYPE;
503: BEGIN
504: OPEN csr_child_end_date;
505:
506: LOOP

Line 567: l_range_table_number pay_range_tables_f.range_table_number%TYPE;

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;
571: l_high_band pay_ranges_f.high_band%TYPE;

Line 568: l_period_frequency pay_range_tables_f.period_frequency%TYPE;

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;
571: l_high_band pay_ranges_f.high_band%TYPE;
572: l_amount1 pay_ranges_f.amount1%TYPE;

Line 569: l_row_value_uom pay_range_tables_f.row_value_uom%TYPE;

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;
571: l_high_band pay_ranges_f.high_band%TYPE;
572: l_amount1 pay_ranges_f.amount1%TYPE;
573: l_amount2 pay_ranges_f.amount2%TYPE;

Line 887: ,p_range_table_number OUT NOCOPY pay_range_tables_f.range_table_number%TYPE

883:
884: */
885: PROCEDURE split_line (
886: p_line IN VARCHAR2
887: ,p_range_table_number OUT NOCOPY pay_range_tables_f.range_table_number%TYPE
888: ,p_row_value_uom OUT NOCOPY pay_range_tables_f.row_value_uom%TYPE
889: ,p_period_frequency OUT NOCOPY pay_range_tables_f.period_frequency%TYPE
890: ,p_low_band OUT NOCOPY pay_ranges_f.low_band%TYPE
891: ,p_high_band OUT NOCOPY pay_ranges_f.high_band%TYPE

Line 888: ,p_row_value_uom OUT NOCOPY pay_range_tables_f.row_value_uom%TYPE

884: */
885: PROCEDURE split_line (
886: p_line IN VARCHAR2
887: ,p_range_table_number OUT NOCOPY pay_range_tables_f.range_table_number%TYPE
888: ,p_row_value_uom OUT NOCOPY pay_range_tables_f.row_value_uom%TYPE
889: ,p_period_frequency OUT NOCOPY pay_range_tables_f.period_frequency%TYPE
890: ,p_low_band OUT NOCOPY pay_ranges_f.low_band%TYPE
891: ,p_high_band OUT NOCOPY pay_ranges_f.high_band%TYPE
892: ,p_amount1 OUT NOCOPY pay_ranges_f.amount1%TYPE

Line 889: ,p_period_frequency OUT NOCOPY pay_range_tables_f.period_frequency%TYPE

885: PROCEDURE split_line (
886: p_line IN VARCHAR2
887: ,p_range_table_number OUT NOCOPY pay_range_tables_f.range_table_number%TYPE
888: ,p_row_value_uom OUT NOCOPY pay_range_tables_f.row_value_uom%TYPE
889: ,p_period_frequency OUT NOCOPY pay_range_tables_f.period_frequency%TYPE
890: ,p_low_band OUT NOCOPY pay_ranges_f.low_band%TYPE
891: ,p_high_band OUT NOCOPY pay_ranges_f.high_band%TYPE
892: ,p_amount1 OUT NOCOPY pay_ranges_f.amount1%TYPE
893: ,p_amount2 OUT NOCOPY pay_ranges_f.amount2%TYPE