DBA Data[Home] [Help]

APPS.HR_AU_HOLIDAYS dependencies on HR_LOOKUPS

Line 555: FROM hr_lookups

551: AND pap.business_group_id = c_business_group_id
552: AND c_calculation_date BETWEEN pee.effective_start_date AND pee.effective_end_date
553: AND pap.accrual_category = (
554: SELECT lookup_code
555: FROM hr_lookups
556: WHERE lookup_type = 'ABSENCE_CATEGORY'
557: AND meaning = 'Annual Leave');
558:
559: BEGIN

Line 607: hr_lookups hrl,

603: FROM pay_element_entries_f pee,
604: pay_element_entry_values_f pev,
605: pay_input_values_f piv,
606: pay_accrual_plans pap,
607: hr_lookups hrl,
608: per_assignments_f asg,
609: per_periods_of_service pps
610: WHERE pev.element_entry_id = pee.element_entry_id
611: AND pap.accrual_plan_element_type_id = piv.element_type_id