DBA Data[Home] [Help]

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