DBA Data[Home] [Help]

APPS.HR_CN_API dependencies on PER_ASSIGNMENTS_F

Line 894: per_assignments_f asg

890: --
891: CURSOR legsel (p_assignment_id IN NUMBER, p_effective_date IN DATE) IS
892: SELECT pbg.legislation_code
893: FROM per_business_groups pbg,
894: per_assignments_f asg
895: WHERE pbg.business_group_id = asg.business_group_id
896: AND asg.assignment_id = p_assignment_id
897: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_END_date;
898: --