APPS.HR_AU_HOLIDAYS dependencies on PER_ASSIGNMENTS_F

Line 608: per_assignments_f asg,

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
612: AND piv.input_value_id = pev.input_value_id

Line 706: from per_assignments_f a

702: select a.effective_start_date
703: , a.effective_end_date
704: , a.normal_hours
705: , a.frequency
706: from per_assignments_f a
707: where a.assignment_id = p_assignment_id
708: and a.effective_start_date <= p_end_date
709: and a.effective_end_date >= p_start_date
710: order by

Line 731: from per_time_periods tp,per_assignments_f paf

727: cursor c_periods (p_assignment_id number
728: ,p_start_date date
729: ,p_end_date date) is
730: select greatest(tp.start_date,paf.effective_start_date) start_date,least(tp.end_date,paf.effective_end_date) end_date
731: from per_time_periods tp,per_assignments_f paf
732: where paf.assignment_id = p_assignment_id
733: and tp.payroll_id = paf.payroll_id
734: and tp.start_date <= paf.effective_end_date
735: and tp.end_date >= paf.effective_start_date

Line 1072: per_assignments_f asg

1068: NVL(SUM(1+
1069: LEAST(effective_end_date, c_end_date)
1070: - GREATEST(effective_start_date, c_start_date)),0)
1071: FROM
1072: per_assignments_f asg
1073: ,per_assignment_status_types t
1074: WHERE
1075: assignment_id = c_assignment_id
1076: AND t.assignment_status_type_id = asg.assignment_status_type_id