APPS.HXT_TIMECARD_API dependencies on HXT_PAY_ELEMENT_TYPES_F_DDF_V

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