4125: FROM per_periods_of_service
4126: WHERE person_id = p_resource_id
4127: union all
4128: select (final_process_date + NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0)) final_process_date, date_start
4129: from per_periods_of_placement
4130: where person_id = p_resource_id
4131: ORDER BY date_start DESC;
4132:
4133: --Added By Mithun for CWK Terminate Bug
4926: FROM per_periods_of_service
4927: WHERE person_id = p_resource_id
4928: union all
4929: select (final_process_date + NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0)) final_process_date, date_start
4930: from per_periods_of_placement
4931: where person_id = p_resource_id
4932: ORDER BY date_start DESC;
4933:
4934: --Added By Mithun for CWK Terminate Bug