APPS.WIP_RES_USAGE_DEFAULT dependencies on WIP_JOB_DTLS_INTERFACE

Line 16: FROM WIP_JOB_DTLS_INTERFACE

12: Cursor Usage_info (p_group_id number,
13: p_wip_entity_id number,
14: p_organization_id number) IS
15: SELECT operation_seq_num, resource_seq_num
16: FROM WIP_JOB_DTLS_INTERFACE
17: WHERE group_id = p_group_id
18: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
19: AND process_status = WIP_CONSTANTS.RUNNING
20: AND wip_entity_id = p_wip_entity_id

Line 144: UPDATE WIP_JOB_DTLS_INTERFACE

140: END IF;
141:
142: END IF;
143:
144: UPDATE WIP_JOB_DTLS_INTERFACE
145: SET last_update_login = NVL(last_update_login, l_last_update_login),
146: request_id = NVL(request_id, l_request_id),
147: program_application_id = NVL(program_application_id,
148: l_program_application_id ),