DBA Data[Home] [Help]

APPS.HR_PERSON_FLEX_LOGIC dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 509: from per_assignment_status_types ast

505: select ast.per_system_status status
506: , asg.effective_start_date
507: , asg.effective_end_date
508: , asg.organization_id
509: from per_assignment_status_types ast
510: , per_all_assignments_f asg
511: where asg.assignment_status_type_id = ast.assignment_status_type_id
512: and asg.assignment_id = p_assignment_id
513: and asg.effective_start_date <= p_period_end_date