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_NET_CALCULATION_RULES

Line 162: PAY_NET_CALCULATION_RULES PNC,

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
166: AND ELTV.hxt_earning_category = 'ABS'

Line 296: ,PAY_NET_CALCULATION_RULES net

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
299: ,per_assignments_f asm
300: WHERE elt.element_type_id = eltv.element_type_id

Line 339: ,PAY_NET_CALCULATION_RULES net

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
342: ,per_assignments_f asm
343: ,per_people_f ppl -- ER180 Bug Fix

Line 389: ,PAY_NET_CALCULATION_RULES net

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
392: ,per_assignments_f asm
393: WHERE elt.element_type_id = eltv.element_type_id

Line 433: ,PAY_NET_CALCULATION_RULES net

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
436: ,per_assignments_f asm
437: WHERE elt.element_type_id = eltv.element_type_id

Line 458: ,PAY_NET_CALCULATION_RULES net

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
461: ,per_assignments_f asm
462: WHERE elt.element_type_id = eltv.element_type_id