DBA Data[Home] [Help]

APPS.WIP_EAM_RESOURCE_TRANSACTION dependencies on PER_PEOPLE_F

Line 159: from per_people_f

155:
156:
157: CURSOR c_empl_cur(l_temp_res_id2 NUMBER) IS --rhshriva
158: select distinct full_name,person_id,employee_number
159: from per_people_f
160: where
161: TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE
162: and person_id in (select person_id
163: from bom_resource_employees