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_NO_TAX_TABLE_UPLOAD dependencies on PAY_RANGES_F

Line 135: from PAY_RANGES_F

131:
132: CURSOR csr_RANGE_ID(p_RANGE_TABLE_ID NUMBER)
133: is
134: SELECT RANGE_ID, OBJECT_VERSION_NUMBER
135: from PAY_RANGES_F
136: where RANGE_TABLE_ID =p_RANGE_TABLE_ID
137: AND EFFECTIVE_START_DATE >= TO_DATE(p_effective_start_date,'YYYY/MM/DD HH24:MI:SS')
138: AND EFFECTIVE_END_DATE <= TO_DATE(p_effective_end_date,'YYYY/MM/DD HH24:MI:SS');
139:

Line 144: l_Ran_OBJECT_VERSION_NUMBER PAY_RANGES_F.OBJECT_VERSION_NUMBER%TYPE;

140:
141: lr_Legislation_Code CSR_Legislation_Code%ROWTYPE;
142: Legislation_Code PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPE;
143:
144: l_Ran_OBJECT_VERSION_NUMBER PAY_RANGES_F.OBJECT_VERSION_NUMBER%TYPE;
145: l_Prf_OBJECT_VERSION_NUMBER PAY_RANGE_TABLES_F.OBJECT_VERSION_NUMBER%TYPE;
146:
147: l_RANGE_ID PAY_RANGES_F.RANGE_ID%TYPE;
148: l_RANGE_TABLE_ID PAY_RANGE_TABLES_F.RANGE_TABLE_ID%TYPE;

Line 147: l_RANGE_ID PAY_RANGES_F.RANGE_ID%TYPE;

143:
144: l_Ran_OBJECT_VERSION_NUMBER PAY_RANGES_F.OBJECT_VERSION_NUMBER%TYPE;
145: l_Prf_OBJECT_VERSION_NUMBER PAY_RANGE_TABLES_F.OBJECT_VERSION_NUMBER%TYPE;
146:
147: l_RANGE_ID PAY_RANGES_F.RANGE_ID%TYPE;
148: l_RANGE_TABLE_ID PAY_RANGE_TABLES_F.RANGE_TABLE_ID%TYPE;
149:
150: BEGIN
151:

Line 195: /* DELETE FROM PAY_RANGES_F

191:
192:
193:
194:
195: /* DELETE FROM PAY_RANGES_F
196: where RANGE_TABLE_ID in
197: ( select RANGE_TABLE_ID
198: from PAY_RANGE_TABLES_F
199: where LEGISLATION_CODE = Legislation_Code

Line 265: l_low_band PAY_RANGES_F.LOW_BAND%TYPE;

261: -- Values from flat file to be uploaded to Temp Tables
262: l_range_table_num PAY_RANGE_TABLES_F.RANGE_TABLE_NUMBER%TYPE;
263: l_period_frequency PAY_RANGE_TABLES_F.PERIOD_FREQUENCY%TYPE;
264: l_earnings_type PAY_RANGE_TABLES_F.EARNINGS_TYPE%TYPE;
265: l_low_band PAY_RANGES_F.LOW_BAND%TYPE;
266: l_high_band PAY_RANGES_F.HIGH_BAND%TYPE;
267: l_amount1 PAY_RANGES_F.AMOUNT1%TYPE;
268: l_amount2 PAY_RANGES_F.AMOUNT2%TYPE;
269: l_range_id PAY_RANGES_F.RANGE_ID%TYPE;

Line 266: l_high_band PAY_RANGES_F.HIGH_BAND%TYPE;

262: l_range_table_num PAY_RANGE_TABLES_F.RANGE_TABLE_NUMBER%TYPE;
263: l_period_frequency PAY_RANGE_TABLES_F.PERIOD_FREQUENCY%TYPE;
264: l_earnings_type PAY_RANGE_TABLES_F.EARNINGS_TYPE%TYPE;
265: l_low_band PAY_RANGES_F.LOW_BAND%TYPE;
266: l_high_band PAY_RANGES_F.HIGH_BAND%TYPE;
267: l_amount1 PAY_RANGES_F.AMOUNT1%TYPE;
268: l_amount2 PAY_RANGES_F.AMOUNT2%TYPE;
269: l_range_id PAY_RANGES_F.RANGE_ID%TYPE;
270: l_max_range_id PAY_RANGES_F.RANGE_ID%TYPE;

Line 267: l_amount1 PAY_RANGES_F.AMOUNT1%TYPE;

263: l_period_frequency PAY_RANGE_TABLES_F.PERIOD_FREQUENCY%TYPE;
264: l_earnings_type PAY_RANGE_TABLES_F.EARNINGS_TYPE%TYPE;
265: l_low_band PAY_RANGES_F.LOW_BAND%TYPE;
266: l_high_band PAY_RANGES_F.HIGH_BAND%TYPE;
267: l_amount1 PAY_RANGES_F.AMOUNT1%TYPE;
268: l_amount2 PAY_RANGES_F.AMOUNT2%TYPE;
269: l_range_id PAY_RANGES_F.RANGE_ID%TYPE;
270: l_max_range_id PAY_RANGES_F.RANGE_ID%TYPE;
271:

Line 268: l_amount2 PAY_RANGES_F.AMOUNT2%TYPE;

264: l_earnings_type PAY_RANGE_TABLES_F.EARNINGS_TYPE%TYPE;
265: l_low_band PAY_RANGES_F.LOW_BAND%TYPE;
266: l_high_band PAY_RANGES_F.HIGH_BAND%TYPE;
267: l_amount1 PAY_RANGES_F.AMOUNT1%TYPE;
268: l_amount2 PAY_RANGES_F.AMOUNT2%TYPE;
269: l_range_id PAY_RANGES_F.RANGE_ID%TYPE;
270: l_max_range_id PAY_RANGES_F.RANGE_ID%TYPE;
271:
272:

Line 269: l_range_id PAY_RANGES_F.RANGE_ID%TYPE;

265: l_low_band PAY_RANGES_F.LOW_BAND%TYPE;
266: l_high_band PAY_RANGES_F.HIGH_BAND%TYPE;
267: l_amount1 PAY_RANGES_F.AMOUNT1%TYPE;
268: l_amount2 PAY_RANGES_F.AMOUNT2%TYPE;
269: l_range_id PAY_RANGES_F.RANGE_ID%TYPE;
270: l_max_range_id PAY_RANGES_F.RANGE_ID%TYPE;
271:
272:
273: l_dummy_range_table_id PAY_RANGE_TABLES_F.RANGE_TABLE_ID%TYPE;

Line 270: l_max_range_id PAY_RANGES_F.RANGE_ID%TYPE;

266: l_high_band PAY_RANGES_F.HIGH_BAND%TYPE;
267: l_amount1 PAY_RANGES_F.AMOUNT1%TYPE;
268: l_amount2 PAY_RANGES_F.AMOUNT2%TYPE;
269: l_range_id PAY_RANGES_F.RANGE_ID%TYPE;
270: l_max_range_id PAY_RANGES_F.RANGE_ID%TYPE;
271:
272:
273: l_dummy_range_table_id PAY_RANGE_TABLES_F.RANGE_TABLE_ID%TYPE;
274: l_object_version_number PAY_RANGE_TABLES_F.OBJECT_VERSION_NUMBER%TYPE;

Line 371: FROM PAY_RANGES_F

367:
368: CURSOR csr_child_end_date(l_RANGE_TABLE_ID NUMBER)
369: IS
370: SELECT RANGE_ID
371: FROM PAY_RANGES_F
372: WHERE RANGE_TABLE_ID = l_RANGE_TABLE_ID
373: AND EFFECTIVE_START_DATE < p_effective_start_date
374: AND EFFECTIVE_END_DATE <> c_end_of_time;
375:

Line 549: -- and insert into pay_ranges_f table

545:
546: EXIT WHEN csr_range_values_from_main_tab%NOTFOUND;
547: -- For each record in the pay_range_tables_f
548: -- pick up all record one by one from pay_ranges_temp
549: -- and insert into pay_ranges_f table
550:
551: OPEN csr_range_band_val_frm_tmp_tab(l_range_table_num,l_period_frequency,l_earnings_type);
552: LOOP
553: FETCH csr_range_band_val_frm_tmp_tab

Line 641: FROM PAY_RANGES_F

637:
638: CURSOR csr_child_end_date
639: IS
640: SELECT RANGE_ID,object_version_number
641: FROM PAY_RANGES_F
642: WHERE RANGE_TABLE_ID = p_RANGE_TABLE_ID
643: AND EFFECTIVE_START_DATE < p_effective_start_date
644: AND EFFECTIVE_END_DATE = c_end_of_time;
645:

Line 720: l_low_band PAY_RANGES_F.LOW_BAND%TYPE;

716: -- variables which represents columns in PAY_RANGE_TEMP table.
717: l_range_table_number PAY_RANGE_TABLES_F .RANGE_TABLE_NUMBER%TYPE;
718: l_period_frequency PAY_RANGE_TABLES_F .PERIOD_FREQUENCY%TYPE;
719: l_earnings_type PAY_RANGE_TABLES_F .EARNINGS_TYPE%TYPE;
720: l_low_band PAY_RANGES_F.LOW_BAND%TYPE;
721: l_high_band PAY_RANGES_F.HIGH_BAND%TYPE;
722: l_amount1 PAY_RANGES_F.AMOUNT1%TYPE;
723: l_amount2 PAY_RANGES_F.AMOUNT2%TYPE;
724:

Line 721: l_high_band PAY_RANGES_F.HIGH_BAND%TYPE;

717: l_range_table_number PAY_RANGE_TABLES_F .RANGE_TABLE_NUMBER%TYPE;
718: l_period_frequency PAY_RANGE_TABLES_F .PERIOD_FREQUENCY%TYPE;
719: l_earnings_type PAY_RANGE_TABLES_F .EARNINGS_TYPE%TYPE;
720: l_low_band PAY_RANGES_F.LOW_BAND%TYPE;
721: l_high_band PAY_RANGES_F.HIGH_BAND%TYPE;
722: l_amount1 PAY_RANGES_F.AMOUNT1%TYPE;
723: l_amount2 PAY_RANGES_F.AMOUNT2%TYPE;
724:
725: BEGIN

Line 722: l_amount1 PAY_RANGES_F.AMOUNT1%TYPE;

718: l_period_frequency PAY_RANGE_TABLES_F .PERIOD_FREQUENCY%TYPE;
719: l_earnings_type PAY_RANGE_TABLES_F .EARNINGS_TYPE%TYPE;
720: l_low_band PAY_RANGES_F.LOW_BAND%TYPE;
721: l_high_band PAY_RANGES_F.HIGH_BAND%TYPE;
722: l_amount1 PAY_RANGES_F.AMOUNT1%TYPE;
723: l_amount2 PAY_RANGES_F.AMOUNT2%TYPE;
724:
725: BEGIN
726:

Line 723: l_amount2 PAY_RANGES_F.AMOUNT2%TYPE;

719: l_earnings_type PAY_RANGE_TABLES_F .EARNINGS_TYPE%TYPE;
720: l_low_band PAY_RANGES_F.LOW_BAND%TYPE;
721: l_high_band PAY_RANGES_F.HIGH_BAND%TYPE;
722: l_amount1 PAY_RANGES_F.AMOUNT1%TYPE;
723: l_amount2 PAY_RANGES_F.AMOUNT2%TYPE;
724:
725: BEGIN
726:
727: hr_utility.set_location ( 'Entering:' || l_proc, 10);

Line 786: pay_ranges_f_s.nextval,

782: AMOUNT1,
783: AMOUNT2)
784: values
785: (
786: pay_ranges_f_s.nextval,
787: l_RANGE_TABLE_NUMBER,
788: NULL,
789: l_PERIOD_FREQUENCY,
790: l_EARNINGS_TYPE,

Line 983: l_low_band PAY_RANGES_F.LOW_BAND%TYPE;

979:
980: l_range_table_number PAY_RANGE_TABLES_F .RANGE_TABLE_NUMBER%TYPE;
981: l_period_frequency PAY_RANGE_TABLES_F .PERIOD_FREQUENCY%TYPE;
982: l_row_value_uom PAY_RANGE_TABLES_F .EARNINGS_TYPE%TYPE;
983: l_low_band PAY_RANGES_F.LOW_BAND%TYPE;
984: l_amount1 PAY_RANGES_F.AMOUNT1%TYPE;
985: */
986:
987: PROCEDURE split_line

Line 984: l_amount1 PAY_RANGES_F.AMOUNT1%TYPE;

980: l_range_table_number PAY_RANGE_TABLES_F .RANGE_TABLE_NUMBER%TYPE;
981: l_period_frequency PAY_RANGE_TABLES_F .PERIOD_FREQUENCY%TYPE;
982: l_row_value_uom PAY_RANGE_TABLES_F .EARNINGS_TYPE%TYPE;
983: l_low_band PAY_RANGES_F.LOW_BAND%TYPE;
984: l_amount1 PAY_RANGES_F.AMOUNT1%TYPE;
985: */
986:
987: PROCEDURE split_line
988: (

Line 993: ,p_LOW_BAND OUT nocopy PAY_RANGES_F.LOW_BAND%TYPE

989: p_line IN VARCHAR2
990: ,p_RANGE_TABLE_NUMBER OUT nocopy PAY_RANGE_TABLES_F .RANGE_TABLE_NUMBER%TYPE
991: ,p_EARNINGS_TYPE out nocopy PAY_RANGE_TABLES_F .EARNINGS_TYPE%TYPE
992: ,p_PERIOD_FREQUENCY OUT nocopy PAY_RANGE_TABLES_F .PERIOD_FREQUENCY%TYPE
993: ,p_LOW_BAND OUT nocopy PAY_RANGES_F.LOW_BAND%TYPE
994: ,p_AMOUNT1 OUT nocopy PAY_RANGES_F.AMOUNT1%TYPE
995: )
996: is
997:

Line 994: ,p_AMOUNT1 OUT nocopy PAY_RANGES_F.AMOUNT1%TYPE

990: ,p_RANGE_TABLE_NUMBER OUT nocopy PAY_RANGE_TABLES_F .RANGE_TABLE_NUMBER%TYPE
991: ,p_EARNINGS_TYPE out nocopy PAY_RANGE_TABLES_F .EARNINGS_TYPE%TYPE
992: ,p_PERIOD_FREQUENCY OUT nocopy PAY_RANGE_TABLES_F .PERIOD_FREQUENCY%TYPE
993: ,p_LOW_BAND OUT nocopy PAY_RANGES_F.LOW_BAND%TYPE
994: ,p_AMOUNT1 OUT nocopy PAY_RANGES_F.AMOUNT1%TYPE
995: )
996: is
997:
998: -- Procedure name