APPS.EAM_RES_DEFAULT_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 152

                  select unit_of_measure into x_eam_res_rec.uom_code
                    from bom_resources
                    where organization_id = p_eam_res_rec.organization_id
                    and resource_id = p_eam_res_rec.resource_id;

Line: 193

                    select department_id into x_eam_res_rec.department_id
                      from wip_operations
                      where wip_entity_id = p_eam_res_rec.wip_entity_id
                      and organization_id = p_eam_res_rec.organization_id
                      and operation_seq_num = p_eam_res_rec.operation_seq_num;

Line: 241

IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Processing null columns prior update'); END IF;

Line: 458

IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Done processing null columns prior update'); END IF;