APPS.WIP_RES_INST_DEFAULT dependencies on WIP_OPERATION_RESOURCES

Line 33: FROM wip_operation_resources

29: /* If resource_seq_num for the setup instance is null, we need to update
30: with the resource_seq_num of parent setup resource */
31:
32: SELECT resource_seq_num into x_resource_seq
33: FROM wip_operation_resources
34: WHERE organization_id = p_organization_id
35: and wip_entity_id = p_wip_entity_id
36: and operation_seq_num = p_operation_seq_num
37: and resource_id = p_resource_id

Line 50: FROM WIP_OPERATION_RESOURCES

46: /* Derive date_info */
47: if (p_substitution_type = WIP_JOB_DETAILS.wip_add) then
48: SELECT start_date, completion_date
49: INTO x_start_date, x_completion_date
50: FROM WIP_OPERATION_RESOURCES
51: WHERE wip_entity_id = p_wip_entity_id
52: AND organization_id = p_organization_id
53: AND operation_seq_num = p_operation_seq_num
54: AND resource_seq_num = p_resource_seq_num;