APPS.AHL_PP_RESRC_ASSIGN_PVT dependencies on BOM_RESOURCE_EMPLOYEES

Line 156: FROM PER_PEOPLE_F PPF, BOM_RESOURCE_EMPLOYEES BRE, AHL_OPERATION_RESOURCES AOR,

152: BEGIN
153: IF (p_employee_number IS NOT NULL) THEN
154: /*SELECT DISTINCT(PPF.PERSON_ID)
155: INTO x_employee_id
156: FROM PER_PEOPLE_F PPF, BOM_RESOURCE_EMPLOYEES BRE, AHL_OPERATION_RESOURCES AOR,
157: PER_PERSON_TYPES PEPT, AHL_WORKORDERS AWV, AHL_VISITS_B VTB
158: WHERE PPF.PERSON_ID = BRE.PERSON_ID AND BRE.RESOURCE_ID = AOR.RESOURCE_ID
159: AND AWV.VISIT_ID = VTB.VISIT_ID
160: AND BRE.ORGANIZATION_ID = VTB.ORGANIZATION_ID

Line 176: ,bom_resource_employees bre

172: wip_operation_resources wor,
173: wip_operations wo
174: ,ahl_workorders awo, ahl_operation_resources aor
175: , mtl_employees_current_view pf
176: ,bom_resource_employees bre
177: where awo.wip_entity_id = wor.wip_entity_id
178: and awo.workorder_id = p_workorder_id
179: and aor.operation_resource_id = p_oper_resrc_id
180: and wor.resource_seq_num = aor.resource_sequence_num

Line 251: BOM_RESOURCE_EMPLOYEES BRE,

247: IF (p_Employee_Number IS NOT NULL) THEN
248: /*SELECT PPF.PERSON_ID, PPF.FULL_NAME
249: INTO x_employee_id, x_employee_name
250: FROM PER_PEOPLE_F PPF,
251: BOM_RESOURCE_EMPLOYEES BRE,
252: AHL_OPERATION_RESOURCES AOR,
253: PER_PERSON_TYPES PEPT,
254: AHL_WORKORDERS AWV,
255: AHL_VISITS_B VTB

Line 278: ,bom_resource_employees bre

274: wip_operation_resources wor,
275: wip_operations wo
276: ,ahl_workorders awo, ahl_operation_resources aor
277: , mtl_employees_current_view pf
278: ,bom_resource_employees bre
279: where awo.wip_entity_id = wor.wip_entity_id
280: and awo.workorder_id = p_workorder_id
281: and aor.operation_resource_id = p_oper_resrc_id
282: and wor.resource_seq_num = aor.resource_sequence_num

Line 745: BOM_RESOURCE_EMPLOYEES

741: l_scheduled_end_date DATE;
742:
743: CURSOR c_emp_date(employee_id IN NUMBER) IS
744: SELECT EFFECTIVE_START_DATE, EFFECTIVE_END_DATE FROM
745: BOM_RESOURCE_EMPLOYEES
746: WHERE PERSON_ID = employee_id;
747: /*
748: CURSOR c_job_date(job_id IN NUMBER) IS
749: SELECT TO_DATE(SCHEDULED_START_DATE,'DD-MM-YYYY'), TO_DATE(SCHEDULED_END_DATE,'DD-MM-YYYY'),

Line 1114: FROM BOM_DEPT_RES_INSTANCES A, BOM_RESOURCE_EMPLOYEES B

1110: c_resource_id IN NUMBER,
1111: c_dept_id IN NUMBER)
1112: IS
1113: SELECT a.instance_id
1114: FROM BOM_DEPT_RES_INSTANCES A, BOM_RESOURCE_EMPLOYEES B
1115: WHERE A.INSTANCE_ID = B.INSTANCE_ID
1116: AND B.PERSON_ID = c_person_id
1117: AND A.RESOURCE_ID = c_resource_id
1118: AND A.DEPARTMENT_ID in (

Line 2082: FROM BOM_DEPT_RES_INSTANCES A, BOM_RESOURCE_EMPLOYEES B

2078: c_resource_id IN NUMBER,
2079: c_dept_id IN NUMBER)
2080: IS
2081: SELECT a.instance_id
2082: FROM BOM_DEPT_RES_INSTANCES A, BOM_RESOURCE_EMPLOYEES B
2083: WHERE A.INSTANCE_ID = B.INSTANCE_ID
2084: AND B.PERSON_ID = c_person_id
2085: AND A.RESOURCE_ID = c_resource_id
2086: AND A.DEPARTMENT_ID in (