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 249: BOM_RESOURCE_EMPLOYEES BRE,

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

Line 276: ,bom_resource_employees bre

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

Line 743: BOM_RESOURCE_EMPLOYEES

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

Line 1112: FROM BOM_DEPT_RES_INSTANCES A, BOM_RESOURCE_EMPLOYEES B

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

Line 2080: FROM BOM_DEPT_RES_INSTANCES A, BOM_RESOURCE_EMPLOYEES B

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