APPS.HR_AU_HOLIDAYS dependencies on PER_PERIODS_OF_SERVICE

Line 652: FROM per_periods_of_service pps

648:
649: CURSOR c_get_end_date(v_assignment_id NUMBER)
650: IS
651: SELECT LEAST(NVL(pps.actual_termination_date,p_calculation_date), p_calculation_date)
652: FROM per_periods_of_service pps
653: ,per_assignments_f paf
654: WHERE paf.assignment_id = v_assignment_id
655: AND paf.period_of_service_id = pps.period_of_service_id;
656:

Line 1831: per_periods_of_service pps

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
1834: AND piv.input_value_id = pev.input_value_id
1835: AND pee.entry_type ='E'

Line 2695: per_periods_of_service pps

2691: pay_element_types_f pet,
2692: pay_element_links_f pel,
2693: pay_element_entries_f pee,
2694: per_assignments_f paf,
2695: per_periods_of_service pps
2696: where pee.element_link_id = pel.element_link_id
2697: and pel.element_type_id = pet.element_type_id
2698: and pet.element_type_id = pap.accrual_plan_element_type_id
2699: and paf.assignment_id = pee.assignment_id