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.HXT_TIMECARD_API dependencies on PAY_ELEMENT_TYPES_F

Line 160: PAY_ELEMENT_TYPES_F PETF,

156:
157: CURSOR acc_plan_cur IS
158: SELECT PAP.ACCRUAL_PLAN_NAME
159: FROM PAY_ACCRUAL_PLANS PAP,
160: PAY_ELEMENT_TYPES_F PETF,
161: HXT_PAY_ELEMENT_TYPES_F_DDF_V ELTV,
162: PAY_NET_CALCULATION_RULES PNC,
163: PAY_INPUT_VALUES_F PIV
164: WHERE PETF.ELEMENT_TYPE_ID = p_element_type_id

Line 161: HXT_PAY_ELEMENT_TYPES_F_DDF_V ELTV,

157: CURSOR acc_plan_cur IS
158: SELECT PAP.ACCRUAL_PLAN_NAME
159: FROM PAY_ACCRUAL_PLANS PAP,
160: PAY_ELEMENT_TYPES_F PETF,
161: HXT_PAY_ELEMENT_TYPES_F_DDF_V ELTV,
162: PAY_NET_CALCULATION_RULES PNC,
163: PAY_INPUT_VALUES_F PIV
164: WHERE PETF.ELEMENT_TYPE_ID = p_element_type_id
165: AND PETF.ELEMENT_TYPE_ID = ELTV.ELEMENT_TYPE_ID

Line 177: FROM PAY_ELEMENT_TYPES_F PETF1,

173: AND p_date_worked BETWEEN ELTV.EFFECTIVE_START_DATE
174: AND ELTV.EFFECTIVE_END_DATE
175: AND EXISTS
176: (SELECT 1
177: FROM PAY_ELEMENT_TYPES_F PETF1,
178: PAY_ELEMENT_CLASSIFICATIONS PEC,
179: PAY_ELEMENT_ENTRIES_F PEEF,
180: PAY_ELEMENT_LINKS_F PELF,
181: PAY_ACCRUAL_PLANS PAP1

Line 293: FROM hxt_pay_element_types_f_ddf_v eltv

289: ,o_lookup_code OUT NOCOPY VARCHAR2) IS
290:
291: Cursor do_accrual_cur is
292: SELECT hours
293: FROM hxt_pay_element_types_f_ddf_v eltv
294: ,pay_element_types_f elt
295: ,PAY_ACCRUAL_PLANS pap
296: ,PAY_NET_CALCULATION_RULES net
297: ,PAY_INPUT_VALUES_F piv

Line 294: ,pay_element_types_f elt

290:
291: Cursor do_accrual_cur is
292: SELECT hours
293: FROM hxt_pay_element_types_f_ddf_v eltv
294: ,pay_element_types_f elt
295: ,PAY_ACCRUAL_PLANS pap
296: ,PAY_NET_CALCULATION_RULES net
297: ,PAY_INPUT_VALUES_F piv
298: ,hxt_sum_hours_worked sm

Line 317: FROM PAY_ELEMENT_TYPES_F PETF1,

313: AND sm.tim_id = p_tim_id
314: -- Begin ER180, to find accrual plan assigned for an emp.
315: AND PAP.ACCRUAL_PLAN_NAME IN
316: (SELECT PAP1.ACCRUAL_PLAN_NAME
317: FROM PAY_ELEMENT_TYPES_F PETF1,
318: PAY_ELEMENT_CLASSIFICATIONS PEC,
319: PAY_ELEMENT_ENTRIES_F PEEF,
320: PAY_ELEMENT_LINKS_F PELF,
321: PAY_ACCRUAL_PLANS PAP1

Line 336: FROM hxt_pay_element_types_f_ddf_v eltv

332: -- End ER180
333:
334: CURSOR accrual_cur(p_date_worked hxt_sum_hours_worked.date_worked%TYPE) IS
335: SELECT distinct pap.accrual_plan_name
336: FROM hxt_pay_element_types_f_ddf_v eltv
337: ,pay_element_types_f elt
338: ,PAY_ACCRUAL_PLANS pap
339: ,PAY_NET_CALCULATION_RULES net
340: ,PAY_INPUT_VALUES_F piv

Line 337: ,pay_element_types_f elt

333:
334: CURSOR accrual_cur(p_date_worked hxt_sum_hours_worked.date_worked%TYPE) IS
335: SELECT distinct pap.accrual_plan_name
336: FROM hxt_pay_element_types_f_ddf_v eltv
337: ,pay_element_types_f elt
338: ,PAY_ACCRUAL_PLANS pap
339: ,PAY_NET_CALCULATION_RULES net
340: ,PAY_INPUT_VALUES_F piv
341: ,hxt_sum_hours_worked sm

Line 367: FROM PAY_ELEMENT_TYPES_F PETF1

363: and ppl.effective_end_date -- ER180 Bug Fix
364: -- Begin ER180, to find accrual plan assigned for an emp
365: AND PAP.ACCRUAL_PLAN_NAME IN
366: (SELECT PAP1.ACCRUAL_PLAN_NAME
367: FROM PAY_ELEMENT_TYPES_F PETF1
368: ,PAY_ELEMENT_CLASSIFICATIONS PEC
369: ,PAY_ELEMENT_ENTRIES_F PEEF
370: ,PAY_ELEMENT_LINKS_F PELF
371: ,PAY_ACCRUAL_PLANS PAP1

Line 386: FROM hxt_pay_element_types_f_ddf_v eltv

382: -- End ER180
383:
384: Cursor on_timecard_cur(p_accrual_plan_name VARCHAR2) is
385: SELECT sum(sm.hours*(-1)*(net.add_or_subtract))
386: FROM hxt_pay_element_types_f_ddf_v eltv
387: ,pay_element_types_f elt
388: ,PAY_ACCRUAL_PLANS pap
389: ,PAY_NET_CALCULATION_RULES net
390: ,PAY_INPUT_VALUES_F piv

Line 387: ,pay_element_types_f elt

383:
384: Cursor on_timecard_cur(p_accrual_plan_name VARCHAR2) is
385: SELECT sum(sm.hours*(-1)*(net.add_or_subtract))
386: FROM hxt_pay_element_types_f_ddf_v eltv
387: ,pay_element_types_f elt
388: ,PAY_ACCRUAL_PLANS pap
389: ,PAY_NET_CALCULATION_RULES net
390: ,PAY_INPUT_VALUES_F piv
391: ,hxt_sum_hours_worked sm

Line 430: FROM hxt_pay_element_types_f_ddf_v eltv

426: where id=p_tim_id);
427:
428: cursor get_retro_total(p_accrual_plan_name VARCHAR2,p_batch_id number) is
429: SELECT nvl(sum(det.hours*(-1)*(net.add_or_subtract)),0)
430: FROM hxt_pay_element_types_f_ddf_v eltv
431: ,pay_element_types_f elt
432: ,PAY_ACCRUAL_PLANS pap
433: ,PAY_NET_CALCULATION_RULES net
434: ,PAY_INPUT_VALUES_F piv

Line 431: ,pay_element_types_f elt

427:
428: cursor get_retro_total(p_accrual_plan_name VARCHAR2,p_batch_id number) is
429: SELECT nvl(sum(det.hours*(-1)*(net.add_or_subtract)),0)
430: FROM hxt_pay_element_types_f_ddf_v eltv
431: ,pay_element_types_f elt
432: ,PAY_ACCRUAL_PLANS pap
433: ,PAY_NET_CALCULATION_RULES net
434: ,PAY_INPUT_VALUES_F piv
435: ,hxt_det_hours_worked_f det

Line 455: FROM hxt_pay_element_types_f_ddf_v eltv

451:
452:
453: cursor get_org_total(p_accrual_plan_name VARCHAR2) is
454: SELECT nvl(sum(det.hours*(-1)*(net.add_or_subtract)),0)
455: FROM hxt_pay_element_types_f_ddf_v eltv
456: ,pay_element_types_f elt
457: ,PAY_ACCRUAL_PLANS pap
458: ,PAY_NET_CALCULATION_RULES net
459: ,PAY_INPUT_VALUES_F piv

Line 456: ,pay_element_types_f elt

452:
453: cursor get_org_total(p_accrual_plan_name VARCHAR2) is
454: SELECT nvl(sum(det.hours*(-1)*(net.add_or_subtract)),0)
455: FROM hxt_pay_element_types_f_ddf_v eltv
456: ,pay_element_types_f elt
457: ,PAY_ACCRUAL_PLANS pap
458: ,PAY_NET_CALCULATION_RULES net
459: ,PAY_INPUT_VALUES_F piv
460: ,hxt_det_hours_worked_f det

Line 480: hxt_pay_element_types_f_ddf_v eltv

476:
477: cursor get_tc_dates(p_tim_id NUMBER) is
478: SELECT date_worked
479: FROM hxt_det_hours_worked_f det,
480: hxt_pay_element_types_f_ddf_v eltv
481: WHERE det.tim_id=p_tim_id
482: AND eltv.hxt_earning_category = 'ABS'
483: AND det.element_type_id = eltv.element_type_id
484: ORDER BY det.date_worked;