DBA Data[Home] [Help]

APPS.WIP_WS_UTIL dependencies on BOM_RESOURCE_EMPLOYEES

Line 357: BOM_RESOURCE_EMPLOYEES BRE

353: FROM PER_PEOPLE_F P,
354: PER_ASSIGNMENTS_F A,
355: PER_PERSON_TYPES T,
356: HR_ORGANIZATION_UNITS ORG,
357: BOM_RESOURCE_EMPLOYEES BRE
358: WHERE A.PERSON_ID = P.PERSON_ID AND
359: ORG.BUSINESS_GROUP_ID = P.BUSINESS_GROUP_ID AND
360: A.PRIMARY_FLAG = 'Y' AND
361: A.ASSIGNMENT_TYPE = 'E' AND

Line 382: BOM_RESOURCE_EMPLOYEES BRE

378: FROM PER_PEOPLE_F P,
379: PER_ASSIGNMENTS_F A,
380: PER_PERSON_TYPES T,
381: HR_ORGANIZATION_UNITS ORG,
382: BOM_RESOURCE_EMPLOYEES BRE
383: WHERE A.PERSON_ID = P.PERSON_ID AND
384: ORG.BUSINESS_GROUP_ID = P.BUSINESS_GROUP_ID AND
385: A.PRIMARY_FLAG = 'Y' AND
386: A.ASSIGNMENT_TYPE = 'C' AND

Line 1148: from bom_resource_employees bremp

1144: where resource_id = p_resource_id;
1145:
1146: cursor emp_id_cursor is
1147: select person_id
1148: from bom_resource_employees bremp
1149: where instance_id = p_instance_id;
1150:
1151: cursor equipment_cursor is
1152: select msik.concatenated_segments