DBA Data[Home] [Help]

APPS.HR_CN_API dependencies on PER_ASSIGNMENTS_F

Line 886: per_assignments_f asg

882: --
883: CURSOR legsel (p_assignment_id IN NUMBER, p_effective_date IN DATE) IS
884: SELECT pbg.legislation_code
885: FROM per_business_groups pbg,
886: per_assignments_f asg
887: WHERE pbg.business_group_id = asg.business_group_id
888: AND asg.assignment_id = p_assignment_id
889: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_END_date;
890: --