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_TIMEKEEPER_UTILITIES dependencies on PER_PERIODS_OF_SERVICE

Line 1276: per_periods_of_service

1272: /*ADVICE(1203): This definition hides another one [556] */
1273: /* NUMBER
1274: ) IS
1275: select max(date_start) from
1276: per_periods_of_service
1277: where person_id = p_resource_id; */
1278:
1279:
1280:

Line 1314: FROM per_periods_of_service

1310: CURSOR c_emp_hireinfo ( p_resource_id NUMBER,
1311: p_tc_start_date DATE,
1312: p_tc_end_date DATE )
1313: IS SELECT date_start
1314: FROM per_periods_of_service
1315: WHERE person_id = p_resource_id
1316: AND date_start <= p_tc_end_date
1317: AND COALESCE(final_process_date,actual_termination_date,
1318: hr_general.end_of_time) >= p_tc_start_date

Line 1335: FROM per_periods_of_service

1331: /* CURSOR c_emp_terminateinfo(
1332: p_resource_id NUMBER
1333: ) IS
1334: SELECT final_process_date, date_start
1335: FROM per_periods_of_service
1336: WHERE person_id = p_resource_id
1337: union all
1338: SELECT (final_process_date + NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0)) final_process_date, date_start
1339: FROM PER_PERIODS_OF_placement

Line 1360: FROM per_periods_of_service

1356: p_tc_start_date DATE,
1357: p_tc_end_date DATE )
1358: IS SELECT final_process_date,
1359: date_start
1360: FROM per_periods_of_service
1361: WHERE person_id = p_resource_id
1362: AND date_start <= p_tc_end_date
1363: AND COALESCE(final_process_date,actual_termination_date,
1364: hr_general.end_of_time) >= p_tc_start_date

Line 1549: per_periods_of_service

1545: /*ADVICE(1315): This definition hides another one [556] */
1546: /* NUMBER
1547: ) IS
1548: select max(date_start) from
1549: per_periods_of_service
1550: where person_id = p_resource_id;
1551: /*SELECT MIN (effective_start_date)
1552: FROM per_people_f
1553: WHERE person_id = p_resource_id;*/

Line 1570: FROM per_periods_of_service

1566:
1567: CURSOR c_emp_hireinfo ( p_resource_id NUMBER,
1568: p_past_date DATE )
1569: IS SELECT date_start
1570: FROM per_periods_of_service
1571: WHERE person_id = p_resource_id
1572: AND COALESCE(final_process_date,actual_termination_date,
1573: hr_general.end_of_time) > p_past_date
1574: UNION

Line 1590: FROM per_periods_of_service

1586: CURSOR c_emp_terminateinfo(
1587: p_resource_id NUMBER
1588: ) IS
1589: SELECT final_process_date, date_start
1590: FROM per_periods_of_service
1591: WHERE person_id = p_resource_id
1592: union all
1593: select (final_process_date + NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0)) final_process_date, date_start
1594: from per_periods_of_placement

Line 1617: FROM per_periods_of_service

1613: NVL(LEAD(date_start) OVER (ORDER BY date_start)-1,hr_general.end_of_time) end_date
1614: FROM ( SELECT date_start,
1615: COALESCE(final_process_date+1,actual_termination_date+1,hr_general.end_of_time)
1616: final_process_date
1617: FROM per_periods_of_service
1618: WHERE person_id = p_resource_id
1619: UNION
1620: SELECT date_start,
1621: COALESCE((final_process_date+NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0))+1,actual_termination_date+1,hr_general.end_of_time)

Line 2836: FROM per_periods_of_service

2832: CURSOR c_emp_terminateinfo(
2833: p_resource_id NUMBER
2834: ) IS
2835: SELECT final_process_date, date_start
2836: FROM per_periods_of_service
2837: WHERE person_id = p_resource_id
2838: union all
2839: select (final_process_date + NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0)) final_process_date, date_start
2840: from per_periods_of_placement