DBA Data[Home] [Help]

APPS.HR_AU_HOLIDAYS dependencies on HR_LOOKUPS

Line 1777: FROM hr_lookups

1773: AND pap.business_group_id = c_business_group_id
1774: AND c_calculation_date BETWEEN pee.effective_start_date AND pee.effective_end_date
1775: AND pap.accrual_category = (
1776: SELECT lookup_code
1777: FROM hr_lookups
1778: WHERE lookup_type = 'ABSENCE_CATEGORY'
1779: AND meaning = 'Annual Leave');
1780:
1781: BEGIN

Line 1829: hr_lookups hrl,

1825: FROM pay_element_entries_f pee,
1826: pay_element_entry_values_f pev,
1827: pay_input_values_f piv,
1828: pay_accrual_plans pap,
1829: hr_lookups hrl,
1830: per_assignments_f asg,
1831: per_periods_of_service pps
1832: WHERE pev.element_entry_id = pee.element_entry_id
1833: AND pap.accrual_plan_element_type_id = piv.element_type_id