APPS.AHL_LTP_RESRC_LEVL_PVT dependencies on WIP_OPERATIONS

Line 4756: FROM wip_operations

4752: CURSOR wip_oper_cur (c_wip_entity_id IN NUMBER,
4753: c_dept_id IN NUMBER)
4754: IS
4755: SELECT wip_entity_id
4756: FROM wip_operations
4757: WHERE wip_entity_id = c_wip_entity_id
4758: AND department_id = c_dept_id;
4759: --
4760: CURSOR wip_res_cur (c_wip_entity_id IN NUMBER,

Line 4890: FROM wip_operation_resources wor, wip_operations wo, wip_discrete_jobs wdj,

4886: p_x_tp_dtls_tbl IN OUT NOCOPY Time_Period_Details_Tbl_Type
4887: ) IS
4888: CURSOR get_wip_req_dtls_csr IS
4889: SELECT wor.start_date, wor.completion_date, wor.assigned_units, wor.wip_entity_id
4890: FROM wip_operation_resources wor, wip_operations wo, wip_discrete_jobs wdj,
4891: AHL_WORKORDERS aw
4892: WHERE wor.resource_id = p_resource_id
4893: AND wo.department_id = p_dept_id
4894: AND wo.wip_entity_id = wor.wip_entity_id