APPS.HXC_TIMEKEEPER_UTILITIES dependencies on PER_PERIODS_OF_PLACEMENT

Line 1285: -- 1. Added a UNION with per_periods_of_placement, cos we need

1281: -- Bug 7454062
1282: --
1283: -- Rewrote the above cursor as below.
1284: -- Changes :
1285: -- 1. Added a UNION with per_periods_of_placement, cos we need
1286: -- CWK information also.
1287: -- 2. Added two more input values, the timecard start and stop dates
1288: -- because we want to check which is the hire date which suits the
1289: -- given timecard.

Line 1321: FROM per_periods_of_placement

1317: AND COALESCE(final_process_date,actual_termination_date,
1318: hr_general.end_of_time) >= p_tc_start_date
1319: UNION
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

Line 1339: FROM PER_PERIODS_OF_placement

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: */
1343:

Line 1368: FROM PER_PERIODS_OF_placement

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
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

Line 1576: FROM per_periods_of_placement

1572: AND COALESCE(final_process_date,actual_termination_date,
1573: hr_general.end_of_time) > p_past_date
1574: UNION
1575: SELECT date_start
1576: FROM per_periods_of_placement
1577: WHERE person_id = p_resource_id
1578: AND COALESCE(final_process_date,actual_termination_date,
1579: hr_general.end_of_time) > p_past_date
1580: ORDER BY date_start ;

Line 1594: from per_periods_of_placement

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:
1598:

Line 1623: FROM per_periods_of_placement

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: )
1626: ORDER BY start_date;
1627:

Line 2840: from per_periods_of_placement

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:
2844: --Added By Mithun for CWK Terminate Bug