APPS.HXC_TIMEKEEPER_UTILITIES dependencies on PER_PERIODS_OF_PLACEMENT

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

1299: -- Bug 7454062
1300: --
1301: -- Rewrote the above cursor as below.
1302: -- Changes :
1303: -- 1. Added a UNION with per_periods_of_placement, cos we need
1304: -- CWK information also.
1305: -- 2. Added two more input values, the timecard start and stop dates
1306: -- because we want to check which is the hire date which suits the
1307: -- given timecard.

Line 1339: FROM per_periods_of_placement

1335: AND COALESCE(final_process_date,actual_termination_date,
1336: hr_general.end_of_time) >= p_tc_start_date
1337: UNION
1338: SELECT date_start
1339: FROM per_periods_of_placement
1340: WHERE person_id = p_resource_id
1341: AND date_start <= p_tc_end_date
1342: AND COALESCE((final_process_date+NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0)),actual_termination_date,
1343: hr_general.end_of_time) >= p_tc_start_date

Line 1357: FROM PER_PERIODS_OF_placement

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
1358: WHERE person_id = p_resource_id
1359: ORDER BY date_start DESC;
1360: */
1361:

Line 1386: FROM PER_PERIODS_OF_placement

1382: hr_general.end_of_time) >= p_tc_start_date
1383: UNION
1384: SELECT (final_process_date + NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0)) final_process_date,
1385: date_start
1386: FROM PER_PERIODS_OF_placement
1387: WHERE person_id = p_resource_id
1388: AND date_start <= p_tc_end_date
1389: AND COALESCE((final_process_date+NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0)),actual_termination_date,
1390: hr_general.end_of_time) >= p_tc_start_date

Line 1594: FROM per_periods_of_placement

1590: AND COALESCE(final_process_date,actual_termination_date,
1591: hr_general.end_of_time) > p_past_date
1592: UNION
1593: SELECT date_start
1594: FROM per_periods_of_placement
1595: WHERE person_id = p_resource_id
1596: AND COALESCE(final_process_date,actual_termination_date,
1597: hr_general.end_of_time) > p_past_date
1598: ORDER BY date_start ;

Line 1612: from per_periods_of_placement

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
1613: where person_id = p_resource_id
1614: ORDER BY date_start DESC;
1615:
1616:

Line 1641: FROM per_periods_of_placement

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)
1640: final_process_date
1641: FROM per_periods_of_placement
1642: WHERE person_id = p_resource_id
1643: )
1644: ORDER BY start_date;
1645:

Line 2858: from per_periods_of_placement

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
2859: where person_id = p_resource_id
2860: ORDER BY date_start DESC;
2861:
2862: --Added By Mithun for CWK Terminate Bug

Line 4196: FROM per_periods_of_placement

4192: hr_general.end_of_time) >= p_tc_start_date
4193: UNION
4194: SELECT date_start,
4195: (final_process_date + NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0)) final_process_date
4196: FROM per_periods_of_placement
4197: WHERE person_id = p_resource_id
4198: AND date_start <= p_tc_end_date
4199: AND COALESCE((final_process_date+NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0))
4200: ,actual_termination_date,