APPS.HXC_TIMECARD_UTILITIES dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 1636: per_assignment_status_types typ

1632: SELECT pas.ASSIGNMENT_ID,
1633: pas.EFFECTIVE_START_DATE,
1634: NVL(pas.EFFECTIVE_END_DATE, hr_general.end_of_time)
1635: FROM PER_ALL_ASSIGNMENTS_F pas,
1636: per_assignment_status_types typ
1637: ,per_periods_of_service ppos --14596859
1638: WHERE pas.PERSON_ID = p_resource_id
1639: AND pas.ASSIGNMENT_TYPE in ('E','C')
1640: AND pas.PRIMARY_FLAG = 'Y'

Line 1661: , per_assignment_status_types typ

1657: SELECT pas.assignment_id
1658: , pas.effective_start_date
1659: , nvl (pas.effective_end_date, hr_general.end_of_time) end_date
1660: FROM per_all_assignments_f pas
1661: , per_assignment_status_types typ
1662: WHERE pas.person_id = p_resource_id
1663: AND pas.assignment_type IN ('E', 'C')
1664: AND pas.primary_flag = 'Y'
1665: AND pas.assignment_status_type_id = typ.assignment_status_type_id

Line 1807: per_assignment_status_types typ

1803: SELECT pas.ASSIGNMENT_ID,
1804: pas.EFFECTIVE_START_DATE,
1805: NVL(pas.EFFECTIVE_END_DATE, hr_general.end_of_time)
1806: FROM PER_ALL_ASSIGNMENTS_F pas,
1807: per_assignment_status_types typ
1808: WHERE pas.PERSON_ID = p_resource_id
1809: AND pas.ASSIGNMENT_TYPE = 'E'
1810: AND pas.PRIMARY_FLAG = 'Y'
1811: AND pas.ASSIGNMENT_STATUS_TYPE_ID = typ.ASSIGNMENT_STATUS_TYPE_ID