DBA Data[Home] [Help]

APPS.HXT_UTIL dependencies on PAY_ACCRUAL_PLANS

Line 273: FROM PAY_ACCRUAL_PLANS_V

269: PTO_ELEMENT_NAME,
270: PTO_INPUT_VALUE_ID,
271:
272: PTO_INPUT_VALUE_NAME
273: FROM PAY_ACCRUAL_PLANS_V
274: WHERE PTO_ELEMENT_TYPE_ID = p_element_type_id;
275: --
276: -- Total all hours for Absence Element for current pay period
277: --

Line 1621: PAY_ACCRUAL_PLANS PAP

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
1622: WHERE
1623: PEEF.ASSIGNMENT_ID=P_assignment_id
1624: AND PETF.CLASSIFICATION_ID=PEC.CLASSIFICATION_ID
1625: AND UPPER(PEC.CLASSIFICATION_NAME) LIKE UPPER('PTO Accrual%')

Line 1760: pay_accrual_plans pap

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
1764: AND pel.element_link_id = pee.element_link_id