eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_TIMECARD_UTILITIES dependencies on PER_PERIODS_OF_SERVICE

Line 1637: ,per_periods_of_service ppos --14596859

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'
1641: AND pas.ASSIGNMENT_STATUS_TYPE_ID = typ.ASSIGNMENT_STATUS_TYPE_ID

Line 1673: FROM per_periods_of_service ppos

1669: AND (
1670: EXISTS
1671: (
1672: SELECT 1
1673: FROM per_periods_of_service ppos
1674: WHERE ppos.person_id = pas.person_id
1675: AND trunc (sysdate)
1676: BETWEEN trunc (date_start)
1677: AND decode (p_assign_period_limit, 0