APPS.HXT_UTIL dependencies on PAY_ELEMENT_TYPES_F

Line 474: FROM hxt_pay_element_types_f_ddf_v eltv

470: BEGIN
471: BEGIN
472: SELECT eltv.hxt_earning_category
473: INTO l_earning_cat
474: FROM hxt_pay_element_types_f_ddf_v eltv
475: WHERE eltv.element_type_id = p_element_type_id
476: AND p_date_worked BETWEEN eltv.effective_start_date
477: AND eltv.effective_end_date;
478: EXCEPTION

Line 1617: PAY_ELEMENT_TYPES_F PETF,

1613: SELECT
1614: PAP.ACCRUAL_PLAN_ID,
1615: PAP.ACCRUAL_CATEGORY
1616: FROM
1617: PAY_ELEMENT_TYPES_F PETF,
1618: PAY_ELEMENT_CLASSIFICATIONS PEC,
1619: PAY_ELEMENT_ENTRIES_F PEEF,
1620: PAY_ELEMENT_LINKS_F PELF,
1621: PAY_ACCRUAL_PLANS PAP

Line 1759: pay_element_types_f pet,

1755: pap.accrual_category,
1756: pap.business_group_id
1757: FROM pay_element_entries_f pee,
1758: pay_element_links_f pel,
1759: pay_element_types_f pet,
1760: pay_accrual_plans pap
1761: WHERE pee.assignment_id = p_assignment_id
1762: AND p_calculation_date BETWEEN pee.effective_start_date
1763: AND pee.effective_end_date

Line 1828: pay_element_types_f pef,

1824:
1825: SELECT /*+ ORDERED */
1826: SUM(hrw.hours*(-1)*(ncr.add_or_subtract))
1827: FROM hxt_sum_hours_worked_f hrw,
1828: pay_element_types_f pef,
1829: pay_input_values_f piv,
1830: pay_net_calculation_rules ncr
1831: WHERE hrw.tim_id = p_tim_id
1832: AND SYSDATE BETWEEN hrw.effective_start_date