[Home] [Help]
1159: select distinct wrat.wip_entity_id,
1160: wrat.operation_seq_num,wrat.instance_id
1161: from wip_resource_actual_times wrat
1162: where wrat.organization_id = p_organization_id
1163: and ( (wrat.instance_id in (select instance_id from bom_resource_employees where organization_id=p_organization_id and person_id=p_emp_id ) ) or (employee_id=p_emp_id and instance_id is null) )
1164: and wrat.status_type = 1
1165: and wrat.process_status in (2, 3, 4)
1166: and (wrat.time_entry_mode in (3,4) or wrat.process_status = 2)
1167: and wrat.duration is not null;
2228:
2229: CURSOR emp_valid_cursor IS
2230: select bre.person_id
2231: from per_all_people_f papf,
2232: bom_resource_employees bre
2233: where papf.person_id = bre.person_id
2234: and sysdate between papf.effective_start_date and nvl(papf.effective_end_date,sysdate+1)
2235: and bre.organization_id = p_org_id
2236: and papf.employee_number = to_char(p_wip_employee_id)
2239: --Bug 14595358, Contingent Worker Project
2240: CURSOR npw_valid_cursor IS
2241: select bre.person_id
2242: from per_all_people_f papf,
2243: bom_resource_employees bre
2244: where papf.person_id = bre.person_id
2245: and sysdate between papf.effective_start_date and nvl(papf.effective_end_date,sysdate+1)
2246: and bre.organization_id = p_org_id
2247: and papf.npw_number = to_char(p_wip_employee_id)
3270: l_instance_id number;
3271:
3272: cursor instance_id_cursor is
3273: select instance_id
3274: from bom_resource_employees bre
3275: where organization_id = p_org_id
3276: and person_id = p_employee_id;
3277: BEGIN
3278: open instance_id_cursor;