DBA Data[Home] [Help]

APPS.PAY_HXC_DEPOSIT_INTERFACE dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 1025: per_assignment_status_types typ

1021: SELECT pas.BUSINESS_GROUP_ID
1022: , pas.effective_start_date
1023: , pas.effective_end_date
1024: FROM PER_ALL_ASSIGNMENTS_F pas,
1025: per_assignment_status_types typ
1026: WHERE pas.PERSON_ID = p_resource_id
1027: AND pas.ASSIGNMENT_TYPE in ('E','C')
1028: AND pas.PRIMARY_FLAG = 'Y'
1029: AND pas.ASSIGNMENT_STATUS_TYPE_ID = typ.ASSIGNMENT_STATUS_TYPE_ID