DBA Data[Home] [Help]

APPS.HRFASTANSWERS dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 504: from per_assignment_status_types ast

500: select ast.per_system_status status
501: , asg.effective_start_date
502: , asg.effective_end_date
503: , asg.organization_id
504: from per_assignment_status_types ast
505: , per_all_assignments_f asg
506: where asg.assignment_status_type_id = ast.assignment_status_type_id
507: and asg.assignment_id = p_assignment_id
508: and asg.effective_start_date <= p_period_end_date