APPS.BEN_TCS_STMT_PROCESS dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 903: PER_ASSIGNMENT_STATUS_TYPES status

899: v_period_end_date IN DATE)
900: IS
901: SELECT DISTINCT(assignment_id) , assignment_number FROM
902: per_all_assignments_f assign ,
903: PER_ASSIGNMENT_STATUS_TYPES status
904: WHERE assignment_type IN ('B','C','E')
905: AND assign.person_id = v_person_id
906: AND nvl(status.business_group_id,assign.business_group_id) = assign.business_group_id
907: AND status.active_flag = 'Y'