DBA Data[Home] [Help]

APPS.PAY_HXC_DEPOSIT_INTERFACE dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 1051: per_assignment_status_types typ

1047: SELECT pas.BUSINESS_GROUP_ID
1048: , pas.effective_start_date
1049: , pas.effective_end_date
1050: FROM PER_ALL_ASSIGNMENTS_F pas,
1051: per_assignment_status_types typ
1052: WHERE pas.PERSON_ID = p_resource_id
1053: AND pas.ASSIGNMENT_TYPE in ('E','C')
1054: AND pas.PRIMARY_FLAG = 'Y'
1055: AND pas.ASSIGNMENT_STATUS_TYPE_ID = typ.ASSIGNMENT_STATUS_TYPE_ID