DBA Data[Home] [Help]

APPS.WIP_WS_TIME_ENTRY dependencies on BOM_RESOURCE_EMPLOYEES

Line 1764: bom_resource_employees bre

1760:
1761: CURSOR emp_valid_cursor IS
1762: select bre.person_id
1763: from per_all_people_f papf,
1764: bom_resource_employees bre
1765: where papf.person_id = bre.person_id
1766: and sysdate between papf.effective_start_date and nvl(papf.effective_end_date,sysdate+1)
1767: and bre.organization_id = p_org_id
1768: and papf.employee_number = p_wip_employee_id

Line 2530: from bom_resource_employees bre

2526: l_instance_id number;
2527:
2528: cursor instance_id_cursor is
2529: select instance_id
2530: from bom_resource_employees bre
2531: where organization_id = p_org_id
2532: and person_id = p_employee_id;
2533: BEGIN
2534: open instance_id_cursor;