APPS.HXC_TIMEKEEPER_UTILITIES dependencies on PER_PERIODS_OF_SERVICE

Line 1294: per_periods_of_service

1290: /*ADVICE(1203): This definition hides another one [556] */
1291: /* NUMBER
1292: ) IS
1293: select max(date_start) from
1294: per_periods_of_service
1295: where person_id = p_resource_id; */
1296:
1297:
1298:

Line 1332: FROM per_periods_of_service

1328: CURSOR c_emp_hireinfo ( p_resource_id NUMBER,
1329: p_tc_start_date DATE,
1330: p_tc_end_date DATE )
1331: IS SELECT date_start
1332: FROM per_periods_of_service
1333: WHERE person_id = p_resource_id
1334: AND date_start <= p_tc_end_date
1335: AND COALESCE(final_process_date,actual_termination_date,
1336: hr_general.end_of_time) >= p_tc_start_date

Line 1353: FROM per_periods_of_service

1349: /* CURSOR c_emp_terminateinfo(
1350: p_resource_id NUMBER
1351: ) IS
1352: SELECT final_process_date, date_start
1353: FROM per_periods_of_service
1354: WHERE person_id = p_resource_id
1355: union all
1356: SELECT (final_process_date + NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0)) final_process_date, date_start
1357: FROM PER_PERIODS_OF_placement

Line 1378: FROM per_periods_of_service

1374: p_tc_start_date DATE,
1375: p_tc_end_date DATE )
1376: IS SELECT final_process_date,
1377: date_start
1378: FROM per_periods_of_service
1379: WHERE person_id = p_resource_id
1380: AND date_start <= p_tc_end_date
1381: AND COALESCE(final_process_date,actual_termination_date,
1382: hr_general.end_of_time) >= p_tc_start_date

Line 1567: per_periods_of_service

1563: /*ADVICE(1315): This definition hides another one [556] */
1564: /* NUMBER
1565: ) IS
1566: select max(date_start) from
1567: per_periods_of_service
1568: where person_id = p_resource_id;
1569: /*SELECT MIN (effective_start_date)
1570: FROM per_people_f
1571: WHERE person_id = p_resource_id;*/

Line 1588: FROM per_periods_of_service

1584:
1585: CURSOR c_emp_hireinfo ( p_resource_id NUMBER,
1586: p_past_date DATE )
1587: IS SELECT date_start
1588: FROM per_periods_of_service
1589: WHERE person_id = p_resource_id
1590: AND COALESCE(final_process_date,actual_termination_date,
1591: hr_general.end_of_time) > p_past_date
1592: UNION

Line 1608: FROM per_periods_of_service

1604: CURSOR c_emp_terminateinfo(
1605: p_resource_id NUMBER
1606: ) IS
1607: SELECT final_process_date, date_start
1608: FROM per_periods_of_service
1609: WHERE person_id = p_resource_id
1610: union all
1611: select (final_process_date + NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0)) final_process_date, date_start
1612: from per_periods_of_placement

Line 1635: FROM per_periods_of_service

1631: NVL(LEAD(date_start) OVER (ORDER BY date_start)-1,hr_general.end_of_time) end_date
1632: FROM ( SELECT date_start,
1633: COALESCE(final_process_date+1,actual_termination_date+1,hr_general.end_of_time)
1634: final_process_date
1635: FROM per_periods_of_service
1636: WHERE person_id = p_resource_id
1637: UNION
1638: SELECT date_start,
1639: COALESCE((final_process_date+NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0))+1,actual_termination_date+1,hr_general.end_of_time)

Line 2854: FROM per_periods_of_service

2850: CURSOR c_emp_terminateinfo(
2851: p_resource_id NUMBER
2852: ) IS
2853: SELECT final_process_date, date_start
2854: FROM per_periods_of_service
2855: WHERE person_id = p_resource_id
2856: union all
2857: select (final_process_date + NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0)) final_process_date, date_start
2858: from per_periods_of_placement

Line 4187: FROM per_periods_of_service

4183: is
4184:
4185: SELECT date_start,
4186: final_process_date
4187: FROM per_periods_of_service
4188: WHERE person_id = p_resource_id
4189: AND date_start <= p_tc_end_date
4190: AND COALESCE(final_process_date,
4191: actual_termination_date,