DBA Data[Home] [Help]

APPS.WIP_WS_TIME_ENTRY dependencies on PER_ALL_PEOPLE_F

Line 2231: from per_all_people_f papf,

2227: l_person_id NUMBER := 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

Line 2242: from per_all_people_f papf,

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