APPS.HR_FR_ASG_RULES dependencies on PER_ALL_ASSIGNMENTS_F
Line 67: from per_all_assignments_f asg
63: p_assignment_type in varchar2 ) is
64:
65: cursor csr_existing_assignment is
66: select count(*) 67: from per_all_assignments_f asg 68: where asg.period_of_service_id = p_period_of_service_id
69: and asg.assignment_type = 'E'
70: and asg.assignment_id <> p_assignment_id
71: and asg.effective_start_date <> p_effective_start_date