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.PER_PERDETBU_XMLP_PKG dependencies on HR_DE_TAX_INFORMATION_V

Line 95: HR_DE_TAX_INFORMATION_V HDTV

91: DISTINCT
92: TAX_CLASS
93: INTO L_TAX_CLASS
94: FROM
95: HR_DE_TAX_INFORMATION_V HDTV
96: WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
97: AND HDTV.ELEMENT_ENTRY_ID = CF_OLD_TAX_CLASSFORMULA.ELEMENT_ENTRY_ID
98: AND HDTV.PROCESS_ID <> TO_CHAR(P_CONC_REQUEST_ID);
99: ELSE

Line 105: HR_DE_TAX_INFORMATION_V HDTV

101: DISTINCT
102: TAX_CLASS
103: INTO L_TAX_CLASS
104: FROM
105: HR_DE_TAX_INFORMATION_V HDTV
106: WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
107: AND P_DATE_FROM BETWEEN HDTV.EFFECTIVE_START_DATE
108: AND NVL(HDTV.EFFECTIVE_END_DATE
109: ,P_DATE_FROM);

Line 127: HR_DE_TAX_INFORMATION_V HDTV

123: DISTINCT
124: NO_OF_CHILDREN
125: INTO L_OLD_NOC
126: FROM
127: HR_DE_TAX_INFORMATION_V HDTV
128: WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
129: AND HDTV.ELEMENT_ENTRY_ID = CF_OLD_NOCFORMULA.ELEMENT_ENTRY_ID
130: AND HDTV.PROCESS_ID <> TO_CHAR(P_CONC_REQUEST_ID);
131: ELSE

Line 137: HR_DE_TAX_INFORMATION_V HDTV

133: DISTINCT
134: NO_OF_CHILDREN
135: INTO L_OLD_NOC
136: FROM
137: HR_DE_TAX_INFORMATION_V HDTV
138: WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
139: AND P_DATE_FROM BETWEEN HDTV.EFFECTIVE_START_DATE
140: AND NVL(HDTV.EFFECTIVE_END_DATE
141: ,P_DATE_FROM);

Line 159: HR_DE_TAX_INFORMATION_V HDTV

155: DISTINCT
156: MONTHLY_TAX_FREE_INCOME
157: INTO L_OLD_MTFI
158: FROM
159: HR_DE_TAX_INFORMATION_V HDTV
160: WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
161: AND HDTV.ELEMENT_ENTRY_ID = CF_OLD_MTFIFORMULA.ELEMENT_ENTRY_ID
162: AND HDTV.PROCESS_ID <> TO_CHAR(P_CONC_REQUEST_ID);
163: ELSE

Line 169: HR_DE_TAX_INFORMATION_V HDTV

165: DISTINCT
166: MONTHLY_TAX_FREE_INCOME
167: INTO L_OLD_MTFI
168: FROM
169: HR_DE_TAX_INFORMATION_V HDTV
170: WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
171: AND P_DATE_FROM BETWEEN HDTV.EFFECTIVE_START_DATE
172: AND NVL(HDTV.EFFECTIVE_END_DATE
173: ,P_DATE_FROM);

Line 191: HR_DE_TAX_INFORMATION_V HDTV

187: DISTINCT
188: YEARLY_TAX_FREE_INCOME
189: INTO L_OLD_YTFI
190: FROM
191: HR_DE_TAX_INFORMATION_V HDTV
192: WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
193: AND HDTV.ELEMENT_ENTRY_ID = CF_OLD_YTFIFORMULA.ELEMENT_ENTRY_ID
194: AND HDTV.PROCESS_ID <> TO_CHAR(P_CONC_REQUEST_ID);
195: ELSE

Line 201: HR_DE_TAX_INFORMATION_V HDTV

197: DISTINCT
198: YEARLY_TAX_FREE_INCOME
199: INTO L_OLD_YTFI
200: FROM
201: HR_DE_TAX_INFORMATION_V HDTV
202: WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
203: AND P_DATE_FROM BETWEEN HDTV.EFFECTIVE_START_DATE
204: AND NVL(HDTV.EFFECTIVE_END_DATE
205: ,P_DATE_FROM);

Line 223: HR_DE_TAX_INFORMATION_V HDTV

219: DISTINCT
220: ADDITIONAL_MTH_TAXABLE_INCOME
221: INTO L_OLD_AMTI
222: FROM
223: HR_DE_TAX_INFORMATION_V HDTV
224: WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
225: AND HDTV.ELEMENT_ENTRY_ID = CF_OLD_AMTIFORMULA.ELEMENT_ENTRY_ID
226: AND HDTV.PROCESS_ID <> TO_CHAR(P_CONC_REQUEST_ID);
227: ELSE

Line 233: HR_DE_TAX_INFORMATION_V HDTV

229: DISTINCT
230: ADDITIONAL_MTH_TAXABLE_INCOME
231: INTO L_OLD_AMTI
232: FROM
233: HR_DE_TAX_INFORMATION_V HDTV
234: WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
235: AND P_DATE_FROM BETWEEN HDTV.EFFECTIVE_START_DATE
236: AND NVL(HDTV.EFFECTIVE_END_DATE
237: ,P_DATE_FROM);

Line 255: HR_DE_TAX_INFORMATION_V HDTV

251: DISTINCT
252: ADDITIONAL_YEAR_TAXABLE_INCOME
253: INTO L_OLD_AYTI
254: FROM
255: HR_DE_TAX_INFORMATION_V HDTV
256: WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
257: AND HDTV.ELEMENT_ENTRY_ID = CF_OLD_AYTIFORMULA.ELEMENT_ENTRY_ID
258: AND HDTV.PROCESS_ID <> TO_CHAR(P_CONC_REQUEST_ID);
259: ELSE

Line 265: HR_DE_TAX_INFORMATION_V HDTV

261: DISTINCT
262: ADDITIONAL_YEAR_TAXABLE_INCOME
263: INTO L_OLD_AYTI
264: FROM
265: HR_DE_TAX_INFORMATION_V HDTV
266: WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
267: AND P_DATE_FROM BETWEEN HDTV.EFFECTIVE_START_DATE
268: AND NVL(HDTV.EFFECTIVE_END_DATE
269: ,P_DATE_FROM);

Line 287: HR_DE_TAX_INFORMATION_V HDTV

283: DISTINCT
284: TAX_CLASS
285: INTO L_TAX_CLASS
286: FROM
287: HR_DE_TAX_INFORMATION_V HDTV
288: WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
289: AND HDTV.ELEMENT_ENTRY_ID = CF_NEW_TAX_CLASSFORMULA.ELEMENT_ENTRY_ID
290: AND HDTV.PROCESS_ID = TO_CHAR(P_CONC_REQUEST_ID);
291: ELSE

Line 298: HR_DE_TAX_INFORMATION_V HDTV

294: DISTINCT
295: TAX_CLASS
296: INTO L_TAX_CLASS
297: FROM
298: HR_DE_TAX_INFORMATION_V HDTV
299: WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
300: AND P_DATE_FROM BETWEEN HDTV.EFFECTIVE_START_DATE
301: AND NVL(HDTV.EFFECTIVE_END_DATE
302: ,P_DATE_FROM);

Line 323: HR_DE_TAX_INFORMATION_V HDTV

319: DISTINCT
320: NO_OF_CHILDREN
321: INTO L_NEW_NOC
322: FROM
323: HR_DE_TAX_INFORMATION_V HDTV
324: WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
325: AND HDTV.ELEMENT_ENTRY_ID = CF_NEW_NOCFORMULA.ELEMENT_ENTRY_ID
326: AND HDTV.PROCESS_ID = TO_CHAR(P_CONC_REQUEST_ID);
327: ELSE

Line 334: HR_DE_TAX_INFORMATION_V HDTV

330: DISTINCT
331: NO_OF_CHILDREN
332: INTO L_NEW_NOC
333: FROM
334: HR_DE_TAX_INFORMATION_V HDTV
335: WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
336: AND P_DATE_FROM BETWEEN HDTV.EFFECTIVE_START_DATE
337: AND NVL(HDTV.EFFECTIVE_END_DATE
338: ,P_DATE_FROM);

Line 359: HR_DE_TAX_INFORMATION_V HDTV

355: DISTINCT
356: YEARLY_TAX_FREE_INCOME
357: INTO L_NEW_YTFI
358: FROM
359: HR_DE_TAX_INFORMATION_V HDTV
360: WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
361: AND HDTV.ELEMENT_ENTRY_ID = CF_NEW_YTFIFORMULA.ELEMENT_ENTRY_ID
362: AND HDTV.PROCESS_ID = TO_CHAR(P_CONC_REQUEST_ID);
363: ELSE

Line 370: HR_DE_TAX_INFORMATION_V HDTV

366: DISTINCT
367: YEARLY_TAX_FREE_INCOME
368: INTO L_NEW_YTFI
369: FROM
370: HR_DE_TAX_INFORMATION_V HDTV
371: WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
372: AND P_DATE_FROM BETWEEN HDTV.EFFECTIVE_START_DATE
373: AND NVL(HDTV.EFFECTIVE_END_DATE
374: ,P_DATE_FROM);

Line 395: HR_DE_TAX_INFORMATION_V HDTV

391: DISTINCT
392: ADDITIONAL_YEAR_TAXABLE_INCOME
393: INTO L_NEW_AYTI
394: FROM
395: HR_DE_TAX_INFORMATION_V HDTV
396: WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
397: AND HDTV.ELEMENT_ENTRY_ID = CF_NEW_AYTIFORMULA.ELEMENT_ENTRY_ID
398: AND HDTV.PROCESS_ID = TO_CHAR(P_CONC_REQUEST_ID);
399: ELSE

Line 406: HR_DE_TAX_INFORMATION_V HDTV

402: DISTINCT
403: ADDITIONAL_YEAR_TAXABLE_INCOME
404: INTO L_NEW_AYTI
405: FROM
406: HR_DE_TAX_INFORMATION_V HDTV
407: WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
408: AND P_DATE_FROM BETWEEN HDTV.EFFECTIVE_START_DATE
409: AND NVL(HDTV.EFFECTIVE_END_DATE
410: ,P_DATE_FROM);

Line 431: HR_DE_TAX_INFORMATION_V HDTV

427: DISTINCT
428: ADDITIONAL_MTH_TAXABLE_INCOME
429: INTO L_NEW_AMTI
430: FROM
431: HR_DE_TAX_INFORMATION_V HDTV
432: WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
433: AND HDTV.ELEMENT_ENTRY_ID = CF_NEW_AMTIFORMULA.ELEMENT_ENTRY_ID
434: AND HDTV.PROCESS_ID = TO_CHAR(P_CONC_REQUEST_ID);
435: ELSE

Line 442: HR_DE_TAX_INFORMATION_V HDTV

438: DISTINCT
439: ADDITIONAL_MTH_TAXABLE_INCOME
440: INTO L_NEW_AMTI
441: FROM
442: HR_DE_TAX_INFORMATION_V HDTV
443: WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
444: AND P_DATE_FROM BETWEEN HDTV.EFFECTIVE_START_DATE
445: AND NVL(HDTV.EFFECTIVE_END_DATE
446: ,P_DATE_FROM);

Line 467: HR_DE_TAX_INFORMATION_V HDTV

463: DISTINCT
464: MONTHLY_TAX_FREE_INCOME
465: INTO L_NEW_MTFI
466: FROM
467: HR_DE_TAX_INFORMATION_V HDTV
468: WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
469: AND HDTV.ELEMENT_ENTRY_ID = CF_NEW_MTFIFORMULA.ELEMENT_ENTRY_ID
470: AND HDTV.PROCESS_ID = TO_CHAR(P_CONC_REQUEST_ID);
471: ELSE

Line 478: HR_DE_TAX_INFORMATION_V HDTV

474: DISTINCT
475: MONTHLY_TAX_FREE_INCOME
476: INTO L_NEW_MTFI
477: FROM
478: HR_DE_TAX_INFORMATION_V HDTV
479: WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
480: AND P_DATE_FROM BETWEEN HDTV.EFFECTIVE_START_DATE
481: AND NVL(HDTV.EFFECTIVE_END_DATE
482: ,P_DATE_FROM);