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 FND_PROFILE

Line 1324: AND COALESCE((final_process_date+NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0)),actual_termination_date,

1320: SELECT date_start
1321: FROM per_periods_of_placement
1322: WHERE person_id = p_resource_id
1323: AND date_start <= p_tc_end_date
1324: AND COALESCE((final_process_date+NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0)),actual_termination_date,
1325: hr_general.end_of_time) >= p_tc_start_date
1326: ORDER BY date_start ;
1327:
1328:

Line 1338: SELECT (final_process_date + NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0)) final_process_date, date_start

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
1340: WHERE person_id = p_resource_id
1341: ORDER BY date_start DESC;
1342: */

Line 1366: SELECT (final_process_date + NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0)) final_process_date,

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
1365: UNION
1366: SELECT (final_process_date + NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0)) final_process_date,
1367: date_start
1368: FROM PER_PERIODS_OF_placement
1369: WHERE person_id = p_resource_id
1370: AND date_start <= p_tc_end_date

Line 1371: AND COALESCE((final_process_date+NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0)),actual_termination_date,

1367: date_start
1368: FROM PER_PERIODS_OF_placement
1369: WHERE person_id = p_resource_id
1370: AND date_start <= p_tc_end_date
1371: AND COALESCE((final_process_date+NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0)),actual_termination_date,
1372: hr_general.end_of_time) >= p_tc_start_date
1373: ORDER BY date_start DESC;
1374:
1375:

Line 1394: l_tc_start_date := FND_PROFILE.VALUE('OTL_TK_START_DATE');

1390:
1391:
1392: -- Bug 7454062
1393:
1394: l_tc_start_date := FND_PROFILE.VALUE('OTL_TK_START_DATE');
1395: l_tc_end_date := FND_PROFILE.VALUE('OTL_TK_END_DATE');
1396:
1397: IF p_resource_id IS NOT NULL THEN
1398: IF NOT g_resource_perftab.EXISTS (p_resource_id) THEN

Line 1395: l_tc_end_date := FND_PROFILE.VALUE('OTL_TK_END_DATE');

1391:
1392: -- Bug 7454062
1393:
1394: l_tc_start_date := FND_PROFILE.VALUE('OTL_TK_START_DATE');
1395: l_tc_end_date := FND_PROFILE.VALUE('OTL_TK_END_DATE');
1396:
1397: IF p_resource_id IS NOT NULL THEN
1398: IF NOT g_resource_perftab.EXISTS (p_resource_id) THEN
1399: hxc_preference_evaluation.resource_preferences (

Line 1593: select (final_process_date + NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0)) final_process_date, date_start

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
1595: where person_id = p_resource_id
1596: ORDER BY date_start DESC;
1597:

Line 1621: COALESCE((final_process_date+NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0))+1,actual_termination_date+1,hr_general.end_of_time)

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)
1622: final_process_date
1623: FROM per_periods_of_placement
1624: WHERE person_id = p_resource_id
1625: )

Line 2839: select (final_process_date + NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0)) final_process_date, date_start

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
2841: where person_id = p_resource_id
2842: ORDER BY date_start DESC;
2843: