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_RANGES_F

Line 141: FROM pay_ranges_f

137: CURSOR csr_range_id (p_range_table_id NUMBER)
138: IS
139: SELECT range_id
140: ,object_version_number
141: FROM pay_ranges_f
142: WHERE range_table_id = p_range_table_id
143: AND effective_start_date >=
144: TO_DATE (p_effective_start_date, 'YYYY/MM/DD HH24:MI:SS')
145: AND effective_end_date <=

Line 231: l_low_band pay_ranges_f.low_band%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;
235: l_amount3 pay_ranges_f.amount3%TYPE;

Line 232: l_high_band pay_ranges_f.high_band%TYPE;

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;
235: l_amount3 pay_ranges_f.amount3%TYPE;
236: l_amount4 pay_ranges_f.amount4%TYPE;

Line 233: l_amount1 pay_ranges_f.amount1%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;
235: l_amount3 pay_ranges_f.amount3%TYPE;
236: l_amount4 pay_ranges_f.amount4%TYPE;
237: l_amount5 pay_ranges_f.amount5%TYPE;

Line 234: l_amount2 pay_ranges_f.amount2%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;
235: l_amount3 pay_ranges_f.amount3%TYPE;
236: l_amount4 pay_ranges_f.amount4%TYPE;
237: l_amount5 pay_ranges_f.amount5%TYPE;
238: l_amount6 pay_ranges_f.amount6%TYPE;

Line 235: l_amount3 pay_ranges_f.amount3%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;
235: l_amount3 pay_ranges_f.amount3%TYPE;
236: l_amount4 pay_ranges_f.amount4%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;

Line 236: l_amount4 pay_ranges_f.amount4%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;
235: l_amount3 pay_ranges_f.amount3%TYPE;
236: l_amount4 pay_ranges_f.amount4%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;

Line 237: l_amount5 pay_ranges_f.amount5%TYPE;

233: l_amount1 pay_ranges_f.amount1%TYPE;
234: l_amount2 pay_ranges_f.amount2%TYPE;
235: l_amount3 pay_ranges_f.amount3%TYPE;
236: l_amount4 pay_ranges_f.amount4%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;

Line 238: l_amount6 pay_ranges_f.amount6%TYPE;

234: l_amount2 pay_ranges_f.amount2%TYPE;
235: l_amount3 pay_ranges_f.amount3%TYPE;
236: l_amount4 pay_ranges_f.amount4%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;

Line 239: l_amount7 pay_ranges_f.amount7%TYPE;

235: l_amount3 pay_ranges_f.amount3%TYPE;
236: l_amount4 pay_ranges_f.amount4%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;

Line 240: l_amount8 pay_ranges_f.amount8%TYPE;

236: l_amount4 pay_ranges_f.amount4%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;

Line 286: FROM pay_ranges_f

282:
283: CURSOR csr_child_end_date (l_range_table_id NUMBER)
284: IS
285: SELECT range_id
286: FROM pay_ranges_f
287: WHERE range_table_id = l_range_table_id
288: AND effective_start_date < p_effective_start_date
289: AND effective_end_date <> c_end_of_time;
290:

Line 425: -- and insert into pay_ranges_f 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
428: ,MASTER.period_frequency
429: ,MASTER.row_value_uom

Line 496: FROM pay_ranges_f

492: CURSOR csr_child_end_date
493: IS
494: SELECT range_id
495: ,object_version_number
496: FROM pay_ranges_f
497: WHERE range_table_id = p_range_table_id
498: AND effective_start_date < p_effective_start_date
499: AND effective_end_date = c_end_of_time;
500:

Line 570: l_low_band pay_ranges_f.low_band%TYPE;

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;
574: l_amount3 pay_ranges_f.amount3%TYPE;

Line 571: l_high_band pay_ranges_f.high_band%TYPE;

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;
574: l_amount3 pay_ranges_f.amount3%TYPE;
575: l_amount4 pay_ranges_f.amount4%TYPE;

Line 572: l_amount1 pay_ranges_f.amount1%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;
574: l_amount3 pay_ranges_f.amount3%TYPE;
575: l_amount4 pay_ranges_f.amount4%TYPE;
576: l_amount5 pay_ranges_f.amount5%TYPE;

Line 573: l_amount2 pay_ranges_f.amount2%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;
574: l_amount3 pay_ranges_f.amount3%TYPE;
575: l_amount4 pay_ranges_f.amount4%TYPE;
576: l_amount5 pay_ranges_f.amount5%TYPE;
577: l_amount6 pay_ranges_f.amount6%TYPE;

Line 574: l_amount3 pay_ranges_f.amount3%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;
574: l_amount3 pay_ranges_f.amount3%TYPE;
575: l_amount4 pay_ranges_f.amount4%TYPE;
576: l_amount5 pay_ranges_f.amount5%TYPE;
577: l_amount6 pay_ranges_f.amount6%TYPE;
578: l_amount7 pay_ranges_f.amount7%TYPE;

Line 575: l_amount4 pay_ranges_f.amount4%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;
574: l_amount3 pay_ranges_f.amount3%TYPE;
575: l_amount4 pay_ranges_f.amount4%TYPE;
576: l_amount5 pay_ranges_f.amount5%TYPE;
577: l_amount6 pay_ranges_f.amount6%TYPE;
578: l_amount7 pay_ranges_f.amount7%TYPE;
579: l_amount8 pay_ranges_f.amount8%TYPE;

Line 576: l_amount5 pay_ranges_f.amount5%TYPE;

572: l_amount1 pay_ranges_f.amount1%TYPE;
573: l_amount2 pay_ranges_f.amount2%TYPE;
574: l_amount3 pay_ranges_f.amount3%TYPE;
575: l_amount4 pay_ranges_f.amount4%TYPE;
576: l_amount5 pay_ranges_f.amount5%TYPE;
577: l_amount6 pay_ranges_f.amount6%TYPE;
578: l_amount7 pay_ranges_f.amount7%TYPE;
579: l_amount8 pay_ranges_f.amount8%TYPE;
580: -- Local Variables

Line 577: l_amount6 pay_ranges_f.amount6%TYPE;

573: l_amount2 pay_ranges_f.amount2%TYPE;
574: l_amount3 pay_ranges_f.amount3%TYPE;
575: l_amount4 pay_ranges_f.amount4%TYPE;
576: l_amount5 pay_ranges_f.amount5%TYPE;
577: l_amount6 pay_ranges_f.amount6%TYPE;
578: l_amount7 pay_ranges_f.amount7%TYPE;
579: l_amount8 pay_ranges_f.amount8%TYPE;
580: -- Local Variables
581: l_diff_record_type NUMBER := 0;

Line 578: l_amount7 pay_ranges_f.amount7%TYPE;

574: l_amount3 pay_ranges_f.amount3%TYPE;
575: l_amount4 pay_ranges_f.amount4%TYPE;
576: l_amount5 pay_ranges_f.amount5%TYPE;
577: l_amount6 pay_ranges_f.amount6%TYPE;
578: l_amount7 pay_ranges_f.amount7%TYPE;
579: l_amount8 pay_ranges_f.amount8%TYPE;
580: -- Local Variables
581: l_diff_record_type NUMBER := 0;
582:

Line 579: l_amount8 pay_ranges_f.amount8%TYPE;

575: l_amount4 pay_ranges_f.amount4%TYPE;
576: l_amount5 pay_ranges_f.amount5%TYPE;
577: l_amount6 pay_ranges_f.amount6%TYPE;
578: l_amount7 pay_ranges_f.amount7%TYPE;
579: l_amount8 pay_ranges_f.amount8%TYPE;
580: -- Local Variables
581: l_diff_record_type NUMBER := 0;
582:
583: BEGIN

Line 646: VALUES (pay_ranges_f_s.NEXTVAL

642: ,amount6
643: ,amount7
644: ,amount8
645: )
646: VALUES (pay_ranges_f_s.NEXTVAL
647: ,l_range_table_number
648: ,l_row_value_uom
649: ,l_period_frequency
650: ,NULL

Line 890: ,p_low_band OUT NOCOPY pay_ranges_f.low_band%TYPE

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
894: ,p_amount3 OUT NOCOPY pay_ranges_f.amount3%TYPE

Line 891: ,p_high_band OUT NOCOPY pay_ranges_f.high_band%TYPE

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
894: ,p_amount3 OUT NOCOPY pay_ranges_f.amount3%TYPE
895: ,p_amount4 OUT NOCOPY pay_ranges_f.amount4%TYPE

Line 892: ,p_amount1 OUT NOCOPY pay_ranges_f.amount1%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
894: ,p_amount3 OUT NOCOPY pay_ranges_f.amount3%TYPE
895: ,p_amount4 OUT NOCOPY pay_ranges_f.amount4%TYPE
896: ,p_amount5 OUT NOCOPY pay_ranges_f.amount5%TYPE

Line 893: ,p_amount2 OUT NOCOPY pay_ranges_f.amount2%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
894: ,p_amount3 OUT NOCOPY pay_ranges_f.amount3%TYPE
895: ,p_amount4 OUT NOCOPY pay_ranges_f.amount4%TYPE
896: ,p_amount5 OUT NOCOPY pay_ranges_f.amount5%TYPE
897: ,p_amount6 OUT NOCOPY pay_ranges_f.amount6%TYPE

Line 894: ,p_amount3 OUT NOCOPY pay_ranges_f.amount3%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
894: ,p_amount3 OUT NOCOPY pay_ranges_f.amount3%TYPE
895: ,p_amount4 OUT NOCOPY pay_ranges_f.amount4%TYPE
896: ,p_amount5 OUT NOCOPY pay_ranges_f.amount5%TYPE
897: ,p_amount6 OUT NOCOPY pay_ranges_f.amount6%TYPE
898: ,p_amount7 OUT NOCOPY pay_ranges_f.amount7%TYPE

Line 895: ,p_amount4 OUT NOCOPY pay_ranges_f.amount4%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
894: ,p_amount3 OUT NOCOPY pay_ranges_f.amount3%TYPE
895: ,p_amount4 OUT NOCOPY pay_ranges_f.amount4%TYPE
896: ,p_amount5 OUT NOCOPY pay_ranges_f.amount5%TYPE
897: ,p_amount6 OUT NOCOPY pay_ranges_f.amount6%TYPE
898: ,p_amount7 OUT NOCOPY pay_ranges_f.amount7%TYPE
899: ,p_amount8 OUT NOCOPY pay_ranges_f.amount8%TYPE

Line 896: ,p_amount5 OUT NOCOPY pay_ranges_f.amount5%TYPE

892: ,p_amount1 OUT NOCOPY pay_ranges_f.amount1%TYPE
893: ,p_amount2 OUT NOCOPY pay_ranges_f.amount2%TYPE
894: ,p_amount3 OUT NOCOPY pay_ranges_f.amount3%TYPE
895: ,p_amount4 OUT NOCOPY pay_ranges_f.amount4%TYPE
896: ,p_amount5 OUT NOCOPY pay_ranges_f.amount5%TYPE
897: ,p_amount6 OUT NOCOPY pay_ranges_f.amount6%TYPE
898: ,p_amount7 OUT NOCOPY pay_ranges_f.amount7%TYPE
899: ,p_amount8 OUT NOCOPY pay_ranges_f.amount8%TYPE
900: )

Line 897: ,p_amount6 OUT NOCOPY pay_ranges_f.amount6%TYPE

893: ,p_amount2 OUT NOCOPY pay_ranges_f.amount2%TYPE
894: ,p_amount3 OUT NOCOPY pay_ranges_f.amount3%TYPE
895: ,p_amount4 OUT NOCOPY pay_ranges_f.amount4%TYPE
896: ,p_amount5 OUT NOCOPY pay_ranges_f.amount5%TYPE
897: ,p_amount6 OUT NOCOPY pay_ranges_f.amount6%TYPE
898: ,p_amount7 OUT NOCOPY pay_ranges_f.amount7%TYPE
899: ,p_amount8 OUT NOCOPY pay_ranges_f.amount8%TYPE
900: )
901: IS

Line 898: ,p_amount7 OUT NOCOPY pay_ranges_f.amount7%TYPE

894: ,p_amount3 OUT NOCOPY pay_ranges_f.amount3%TYPE
895: ,p_amount4 OUT NOCOPY pay_ranges_f.amount4%TYPE
896: ,p_amount5 OUT NOCOPY pay_ranges_f.amount5%TYPE
897: ,p_amount6 OUT NOCOPY pay_ranges_f.amount6%TYPE
898: ,p_amount7 OUT NOCOPY pay_ranges_f.amount7%TYPE
899: ,p_amount8 OUT NOCOPY pay_ranges_f.amount8%TYPE
900: )
901: IS
902: -- Procedure name

Line 899: ,p_amount8 OUT NOCOPY pay_ranges_f.amount8%TYPE

895: ,p_amount4 OUT NOCOPY pay_ranges_f.amount4%TYPE
896: ,p_amount5 OUT NOCOPY pay_ranges_f.amount5%TYPE
897: ,p_amount6 OUT NOCOPY pay_ranges_f.amount6%TYPE
898: ,p_amount7 OUT NOCOPY pay_ranges_f.amount7%TYPE
899: ,p_amount8 OUT NOCOPY pay_ranges_f.amount8%TYPE
900: )
901: IS
902: -- Procedure name
903: l_proc CONSTANT VARCHAR2 (72) := g_package || '.split_line';