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_RANGE_TABLES_F

Line 112: from PAY_RANGE_TABLES_F

108:
109: CURSOR csr_RANGE_TABLE_ID(p_Legislation_Code PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPE)
110: is
111: select RANGE_TABLE_ID ,OBJECT_VERSION_NUMBER
112: from PAY_RANGE_TABLES_F
113: where LEGISLATION_CODE = p_Legislation_Code
114: AND BUSINESS_GROUP_ID = p_business_group
115: AND EFFECTIVE_START_DATE >= TO_DATE(p_effective_start_date,'YYYY/MM/DD HH24:MI:SS')
116: AND EFFECTIVE_END_DATE <= TO_DATE(p_effective_end_date,'YYYY/MM/DD HH24:MI:SS');

Line 126: from PAY_RANGE_TABLES_F

122:
123: CURSOR csr_RANGE_TABLE_ID(p_Legislation_Code PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPE)
124: is
125: select RANGE_TABLE_ID ,OBJECT_VERSION_NUMBER
126: from PAY_RANGE_TABLES_F
127: where LEGISLATION_CODE = p_Legislation_Code
128: AND EFFECTIVE_START_DATE >= TO_DATE(p_effective_start_date,'YYYY/MM/DD HH24:MI:SS')
129: AND EFFECTIVE_END_DATE <= TO_DATE(p_effective_end_date,'YYYY/MM/DD HH24:MI:SS');
130:

Line 145: l_Prf_OBJECT_VERSION_NUMBER PAY_RANGE_TABLES_F.OBJECT_VERSION_NUMBER%TYPE;

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;
149:

Line 148: l_RANGE_TABLE_ID PAY_RANGE_TABLES_F.RANGE_TABLE_ID%TYPE;

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:
152: --hr_utility.trace_on(null,'tax');

Line 198: from PAY_RANGE_TABLES_F

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
200: AND BUSINESS_GROUP_ID = p_business_group
201: AND EFFECTIVE_START_DATE >= TO_DATE(p_effective_start_date,'YYYY/MM/DD HH24:MI:SS')
202: AND EFFECTIVE_END_DATE <= TO_DATE(p_effective_end_date,'YYYY/MM/DD HH24:MI:SS')

Line 208: DELETE FROM PAY_RANGE_TABLES_F

204: AND EFFECTIVE_START_DATE >= TO_DATE(p_effective_start_date,'YYYY/MM/DD HH24:MI:SS')
205: AND EFFECTIVE_END_DATE <= TO_DATE(p_effective_end_date,'YYYY/MM/DD HH24:MI:SS');
206:
207:
208: DELETE FROM PAY_RANGE_TABLES_F
209: WHERE LEGISLATION_CODE = Legislation_Code
210: AND BUSINESS_GROUP_ID = p_business_group
211: AND EFFECTIVE_START_DATE >= TO_DATE(p_effective_start_date,'YYYY/MM/DD HH24:MI:SS')
212: AND EFFECTIVE_END_DATE <= TO_DATE(p_effective_end_date,'YYYY/MM/DD HH24:MI:SS');

Line 259: l_pay_f_range_table_id PAY_RANGE_TABLES_F.RANGE_TABLE_ID%TYPE;

255: IS
256:
257: l_proc CONSTANT VARCHAR2 (72) := g_package||'.Upload_Tax_To_Main_Table' ;
258: -- Automatic Sequence created by API
259: l_pay_f_range_table_id PAY_RANGE_TABLES_F.RANGE_TABLE_ID%TYPE;
260:
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;

Line 262: l_range_table_num PAY_RANGE_TABLES_F.RANGE_TABLE_NUMBER%TYPE;

258: -- Automatic Sequence created by API
259: l_pay_f_range_table_id PAY_RANGE_TABLES_F.RANGE_TABLE_ID%TYPE;
260:
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;

Line 263: l_period_frequency PAY_RANGE_TABLES_F.PERIOD_FREQUENCY%TYPE;

259: l_pay_f_range_table_id PAY_RANGE_TABLES_F.RANGE_TABLE_ID%TYPE;
260:
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;

Line 264: l_earnings_type PAY_RANGE_TABLES_F.EARNINGS_TYPE%TYPE;

260:
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;

Line 273: l_dummy_range_table_id PAY_RANGE_TABLES_F.RANGE_TABLE_ID%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;
275:
276: l_dummy PAY_RANGE_TABLES_F.OBJECT_VERSION_NUMBER%TYPE;
277:

Line 274: l_object_version_number PAY_RANGE_TABLES_F.OBJECT_VERSION_NUMBER%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;
275:
276: l_dummy PAY_RANGE_TABLES_F.OBJECT_VERSION_NUMBER%TYPE;
277:
278:

Line 276: l_dummy PAY_RANGE_TABLES_F.OBJECT_VERSION_NUMBER%TYPE;

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;
275:
276: l_dummy PAY_RANGE_TABLES_F.OBJECT_VERSION_NUMBER%TYPE;
277:
278:
279: l_csr_range_table_id PAY_RANGE_TABLES_F.RANGE_TABLE_ID%TYPE;
280:

Line 279: l_csr_range_table_id PAY_RANGE_TABLES_F.RANGE_TABLE_ID%TYPE;

275:
276: l_dummy PAY_RANGE_TABLES_F.OBJECT_VERSION_NUMBER%TYPE;
277:
278:
279: l_csr_range_table_id PAY_RANGE_TABLES_F.RANGE_TABLE_ID%TYPE;
280:
281: /*
282: CURSOR csr_data_exists_on_same_date
283: IS

Line 285: FROM PAY_RANGE_TABLES_F

281: /*
282: CURSOR csr_data_exists_on_same_date
283: IS
284: SELECT 'Y'
285: FROM PAY_RANGE_TABLES_F
286: WHERE LEGISLATION_CODE = p_legislation_code
287: AND BUSINESS_GROUP_ID = p_business_group
288: AND EFFECTIVE_START_DATE = p_effective_start_date;
289:

Line 298: FROM PAY_RANGE_TABLES_F

294:
295: CURSOR csr_data_exists_on_same_date
296: IS
297: SELECT 'Y'
298: FROM PAY_RANGE_TABLES_F
299: WHERE LEGISLATION_CODE = p_legislation_code
300: AND BUSINESS_GROUP_ID IS NULL
301: AND EFFECTIVE_START_DATE = p_effective_start_date;
302:

Line 308: FROM PAY_RANGE_TABLES_F

304:
305: CURSOR csr_data_exists_on_future_date
306: IS
307: SELECT 'Y'
308: FROM PAY_RANGE_TABLES_F
309: WHERE LEGISLATION_CODE = p_legislation_code
310: AND BUSINESS_GROUP_ID = p_business_group
311: AND p_effective_start_date BETWEEN
312: EFFECTIVE_START_DATE

Line 323: FROM PAY_RANGE_TABLES_F

319:
320: CURSOR csr_data_exists_on_future_date
321: IS
322: SELECT 'Y'
323: FROM PAY_RANGE_TABLES_F
324: WHERE LEGISLATION_CODE = p_legislation_code
325: AND BUSINESS_GROUP_ID IS NULL
326: AND p_effective_start_date BETWEEN
327: EFFECTIVE_START_DATE

Line 339: FROM PAY_RANGE_TABLES_F

335: l_earnings_type VARCHAR2
336: )
337: IS
338: SELECT RANGE_TABLE_ID,object_version_number
339: FROM PAY_RANGE_TABLES_F
340: WHERE LEGISLATION_CODE = p_legislation_code
341: AND BUSINESS_GROUP_ID = p_business_group
342: AND EFFECTIVE_START_DATE < p_effective_start_date
343: AND RANGE_TABLE_NUMBER = l_RANGE_TABLE_NUMBER

Line 358: FROM PAY_RANGE_TABLES_F

354: l_earnings_type VARCHAR2
355: )
356: IS
357: SELECT RANGE_TABLE_ID,object_version_number
358: FROM PAY_RANGE_TABLES_F
359: WHERE LEGISLATION_CODE = p_legislation_code
360: AND BUSINESS_GROUP_ID IS NULL
361: AND EFFECTIVE_START_DATE < p_effective_start_date
362: AND RANGE_TABLE_NUMBER = l_RANGE_TABLE_NUMBER

Line 403: FROM PAY_RANGE_TABLES_F

399: SELECT RANGE_TABLE_ID,
400: RANGE_TABLE_NUMBER,
401: PERIOD_FREQUENCY,
402: EARNINGS_TYPE
403: FROM PAY_RANGE_TABLES_F
404: WHERE LEGISLATION_CODE = p_legislation_code
405: AND BUSINESS_GROUP_ID = p_business_group
406: AND EFFECTIVE_START_DATE = p_effective_start_date
407: AND EFFECTIVE_END_DATE = c_end_of_time;

Line 419: FROM PAY_RANGE_TABLES_F

415: SELECT RANGE_TABLE_ID,
416: RANGE_TABLE_NUMBER,
417: PERIOD_FREQUENCY,
418: EARNINGS_TYPE
419: FROM PAY_RANGE_TABLES_F
420: WHERE LEGISLATION_CODE = p_legislation_code
421: AND BUSINESS_GROUP_ID IS NULL
422: AND EFFECTIVE_START_DATE = p_effective_start_date
423: AND EFFECTIVE_END_DATE = c_end_of_time;

Line 547: -- For each record in the pay_range_tables_f

543: l_period_frequency,
544: l_earnings_type;
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);

Line 647: l_object_version_number PAY_RANGE_TABLES_F.OBJECT_VERSION_NUMBER%TYPE;

643: AND EFFECTIVE_START_DATE < p_effective_start_date
644: AND EFFECTIVE_END_DATE = c_end_of_time;
645:
646: l_Range_id number;
647: l_object_version_number PAY_RANGE_TABLES_F.OBJECT_VERSION_NUMBER%TYPE;
648: BEGIN
649:
650: OPEN csr_child_end_date;
651: LOOP

Line 717: l_range_table_number PAY_RANGE_TABLES_F .RANGE_TABLE_NUMBER%TYPE;

713: l_batch_seq NUMBER := 0;
714: l_batch_id NUMBER;
715:
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;

Line 718: l_period_frequency PAY_RANGE_TABLES_F .PERIOD_FREQUENCY%TYPE;

714: l_batch_id NUMBER;
715:
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;

Line 719: l_earnings_type PAY_RANGE_TABLES_F .EARNINGS_TYPE%TYPE;

715:
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;

Line 980: l_range_table_number PAY_RANGE_TABLES_F .RANGE_TABLE_NUMBER%TYPE;

976: e_record_too_long When Record is Too Long.
977:
978:
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;

Line 981: l_period_frequency PAY_RANGE_TABLES_F .PERIOD_FREQUENCY%TYPE;

977:
978:
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: */

Line 982: l_row_value_uom PAY_RANGE_TABLES_F .EARNINGS_TYPE%TYPE;

978:
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:

Line 990: ,p_RANGE_TABLE_NUMBER OUT nocopy PAY_RANGE_TABLES_F .RANGE_TABLE_NUMBER%TYPE

986:
987: PROCEDURE split_line
988: (
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

Line 991: ,p_EARNINGS_TYPE out nocopy PAY_RANGE_TABLES_F .EARNINGS_TYPE%TYPE

987: PROCEDURE split_line
988: (
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: )

Line 992: ,p_PERIOD_FREQUENCY OUT nocopy PAY_RANGE_TABLES_F .PERIOD_FREQUENCY%TYPE

988: (
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